Forum Discussion

Copper Contributor

Aug 17, 2021

Iterative calculation

I want to keep iterative calculation turned on so that when I open a worksheet it doesn't show the circular reference error. Its ok for me to turn on iterative calculation each time I open the works...

Excel on Mac

NikolinoDE

Gold Contributor

Aug 18, 2021

John_W100

I don't own a Mac because my knowledge is very limited, but the VBA code should be the same.

Here is an example: the iterative calculation is activated when the workbook is opened and deactivated again when the workbook is closed.

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

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

I would be happy to know if I could help.

Nikolino

I know I don't know anything (Socrates)

* Kindly Mark and Vote any reply if it helps please, as it will be beneficial to more Community members reading here.