How do I keep Enable Iterative Calculation checked?

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.

Thanks! 

Answer
Answer

Hi,

It looks as I don't have an issue with this but my test was perhaps to good enough to be sure.

- Open the workbook

- Goto to VB Editor with ALT+F11

- Right click on ThisWorkbook & View Code

- Paste following

Private Sub Workbook_Open()
    With Application
        .Iteration = True
        .MaxIterations = 100
        .MaxChange = 0.0001
    End With
End Sub

- Save the workbook in xlsm format.

HTH

Wkr,

 

JP Ronse


If this post answers your question, please mark it as the Answer.
Kind regards,

JP Ronse

If this response answers your question then please mark as Answer.

76 people found this reply helpful

·

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

 
 

Question Info


Last updated January 25, 2021 Views 19,793 Applies to: