I believe the question is generic, but in this case I am using Excel 2007 SP3 MSO and running on Win7 Enterprise (64bit) SP1.

In my example, I have a spreadsheet I use regularly that contains formulas that must be solved iteratively in order to calculate their value. Sometimes when I open the spreadsheet, I get a warning message about a circular reference, and the tool pops up suggesting to guide me to find these cells and 'fix' the formulas to make them non-circular. I then have to decline the tool, go to the Office button, click Excel Options (below), click Formulas in left column, then under Calculation options check 'Enable iterative calculation' and the issue is resolved, the values calculate quickly and I can go to work. Fine, but I've done this literally over a hundred times now with this same spreadsheet!

I'm not even sure what triggers the circular reference warning. When I close the spreadsheet, then reopen, I don't have to do this. If I close Excel entirely, then reopen the spreadsheet, I don't have to do this. It doesn't seem to matter whether I save the spreadsheet or not, if I reopen 'soon' after closing, the option to solve iteratively is still checked and I'm OK. It may be happening when I restart Windows (which I don't do very often), or maybe after running CCleaner.

My question then is this: My preference would be to make iterative calculations a global default with any new spreadsheet, and not to ever have the option uncheck itself with any spreadsheet for which I've saved this way. Is there a way to do this? Does it involve Normal.dot or a registry setting (which I can do), or is VB coding required (not preferred)? Second best would be to make iterative calculations more 'sticky' for a given saved spreadsheet. To do that, I need to understand better what upsets my spreadsheet so that the option occasionally becomes unchecked.

Thanks!