Permanently enable iterative calculation option in excel

Question

Dear Team,

I have several spreadsheets that require the 'Enable Iterative Calculation' to be selected in order to work correctly. Our business calcs require circular calculations on almost every sheet.

Once I have this option checked, it stays active but only for me. It does not stay checked for my co-workers and it has become very frustrating for them.

Is there a way to permanently keep the iteration calculation option active? Any programming that could run in the background to make it permanent?

Please guide.

Thank you!

Answer 1

Hi, I'm Elise, an independent advisor and I'd be happy to help with your issue.

There should be an options to set the global preference for this in:

File > Options > Formulas

https://support.microsoft.com/en-us/office/remo...

Please let me know if you need any further assistance.

Kind Regards,

Elise

Answer 2

Yes, I know that option but how to permanently enable the calculations.

Answer 3

Ah ok, if that options is not retaining it’s value then you can setup a macro which runs on application start to set this.

This thread gives details on how to achieve this:

https://www.mrexcel.com/board/threads/permanent...

Please let me know if you need any further assistance.

Kind Regards,

Elise

Note: This is a non-Microsoft website. The page appears to be providing accurate, safe information. Watch out for ads on the site that may advertise products frequently classified as a PUP (Potentially Unwanted Products). Thoroughly research any product advertised on the site before you decide to download and install it.