Forum Discussion

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...

excel

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