Forum Discussion

John_W100's avatar
John_W100
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 worksheet but not for the people I share the worksheet with each month.

 

( I want to use the circular reference to calculate the effect of income tax in a cashflow)

Excel on Mac

2 Replies

Sort By
  • NikolinoDE's avatar
    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.

  • JKPieterse's avatar
    JKPieterse
    Silver Contributor
    Aug 18, 2021
    1. Record a macro while setting the calculation settings the way you need them to be
    2. Call that macro from the Workbook_Open sub in the ThisWorkbook module of your file
    3. Save your file as file type xlsm and tell your users to enable macros

Resources