marvin_rock
Board Regular
- Joined
- Dec 14, 2009
- Messages
- 62
Hey, quick and easy, I have a HUGE spreadsheet with intentional circular references. Now that it's going out to users that don't have iterative calculations enabled, it's breaking their spreadsheets.
I already have a workbook open macro in place, just need to add a line to ensure iterative calculation is turned on with the following settings
*"Enable iterative calculation"
* Maximum Iterations = 100
* Maximum Change = 0.001
thanks!
I already have a workbook open macro in place, just need to add a line to ensure iterative calculation is turned on with the following settings
*"Enable iterative calculation"
* Maximum Iterations = 100
* Maximum Change = 0.001
thanks!