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

New Contributor

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?

1 Reply

@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