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