How to auto enable circular reference?

[musicgold]

Hi,

I use iterative calculations in all my files, but everyday I have to go and enable circular references in Excel. Is there a permanent setting to allow circular references automatically?

Thanks


Cross posted at:
http://www.mrexcel.com/forum/excel-questions/703387-how-auto-enable-circular-reference.html

[Jan Karel Pieterse]

That setting is controlled by the first file opened in Excel. If you have set one or more files to open automatically when Excel starts, the first of those will determine that setting.

I would simply add a Workbook_Open event to any file that needs iteration:



Private Sub Workbook_Open()
With Application
.Iteration = True
.MaxChange = 0.001
End With
End Sub