Turning Off Circular Refrences on open
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 |
Turning Off Circular Refrences on open
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" wrote in message ... 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 |
All times are GMT +1. The time now is 10:37 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com