Oct 19 2022 03:57 PM
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?
Oct 19 2022 09:05 PM
@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