B
Bhupinder Rayat
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
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