Forum Discussion

easperhe's avatar
easperhe
Copper Contributor
Oct 19, 2022

File option Enable Iterative Calculation getting value from already opened file bug

I have 2 excel test files: iterate.xlsm (with file option "enable iterative calculation" (EIC) checked) and No-Iterate (with file option "enable iterative calculation" (EIC) not check). Each file has a simple circular reference.

 

When I open just that file, everything works as expected. I get a warning with the "No-Iterate" file and no warning with the "Iterate" file. However if I open "No-iterate" and then open "Iterate", the Iterate file will have the file option EIC not checked. So, the file option EIC is being "inherited" from the already opened file. This seems like a bug to me. Am I missing something?

excel
  • easperhe's avatar
    easperhe
    Copper Contributor
    Oct 20, 2022

    easperhe I guess I found a pretty good work-around using these in the "ThisWorkbook" 

     

    Private Sub Workbook_Activate()
        Application.Iteration = True
    End Sub

     

    Private Sub Workbook_Deactivate()
        Application.Iteration = False
    End Sub

Resources