Turning Off Circular Refrences on open

[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

[Tom Ogilvy]

While the settings are stored with the workbook, they are application level
settings, so only the first workbook opened determines the application level
setting. As you say, code does not run before this is checked. So there is
no way you can do this within the subject workbook.

--
Regards,
Tom Ogilvy


"Bhupinder Rayat" <[email protected]> wrote in
message news:[email protected]...
> 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
>
>