Forum Discussion

JackieBM's avatar
JackieBM
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" but it is also greyed out.  How do I change that as well?

 

Thanks

excel

3 Replies

  • tauqeeracma's avatar
    tauqeeracma
    Iron 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's avatar
      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's avatar
        tauqeeracma
        Iron 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

Resources