I frequently use excel files that require iterative calculations. Every time I open one of these files I have to go back into Excel Options to select Iterative Calculation so that it will calculate correctly. The next time I open the file, it's unchecked again. How can I change my settings in Excel so that every time I'm in Excel this is checked? Or change the file settings so that every time I open that file it's at least correct?
Would appreciate some advice as I'm getting really tired of having to do this every time I open Excel.