Hi all,

I have set the max number of Iterations to 1 in calcuation, so I do not get
circular references for a particular workbook, and then turned iterations off
again on close, using the following code...

Private Sub Workbook_Open()

With Application
.Iteration = True
.MaxIterations = 1
.MaxChange = 0.001
End With
ActiveWorkbook.PrecisionAsDisplayed = False

End Sub
Private Sub Workbook_BeforeClose(Cancel As Boolean)

With Application
.Iteration = False
.MaxIterations = 100
.MaxChange = 0.001
End With
ActiveWorkbook.PrecisionAsDisplayed = False

End Sub

The problem is that when I open this workbook again, Excel tells me that I
have circuar references before running Workbook_open() which turns on
iterations, as the current setting has iterations turned off, which I toggled
when closing this workbook.

How can I tell excel not to check for circular references BEFORE running the
workbook_open() sub??

Best regards,


Bhupinder