"Enable Iterative Calculation" greyed out

[JackieBM]

I am trying to check the "Enable Iterative Calculation" box but it is greyed out.  How do I activate it?  I am also trying to select "Automatic Excerpt for Data Tables" under "Workbook Calculation" but it is also greyed out.  How do I change that as well?

Thanks

[#2]

Hi @JackieBM 

Please share the screenshot where these options are greyed out may be something is traceable from there.

Thanks

Tauqeer

[#3]

Hi there. So I noticed if I have an open worksheet I am able to change it. But, is there a way to change it as a default at all times? https://imgur.com/ZWTyrgm

[#4]

Hi @JackieBM 

Generally, calculation options are workbook specific but also note that if there are two files with different calculation options (one with Automatic & other with Manual), the file that is opened secondly will follow the calculation setting of the firstly opened file.

Thanks