Forum Discussion

Copper Contributor

Mar 17, 2021

"Enable Iterative Calculation" greyed out

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" b...

excel

tauqeeracma

Steel Contributor

Mar 17, 2021

Hi JackieBM

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

Thanks

Tauqeer

JackieBM
Copper Contributor
Mar 17, 2021
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
- tauqeeracma
  Steel Contributor
  Mar 17, 2021
  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