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

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

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

Resources