Forum Discussion

Steve Smallman's avatar
Steve Smallman
Copper Contributor
Apr 06, 2018
Solved

Formulae do not recalculate automatically

I've never had this happen before.  I change raw data in a spreadsheet and related calculated cells do not automatically recalculate.  They only recalculate after I go into each cell and then into th...
excel
  • Haytham Amairah's avatar
    Haytham Amairah
    Apr 06, 2018

    Hi Steve,

     

    I don't think the Inspect Document tool is related to this.

     

    It seems that the calculation option in your workbook is set to Manual, to change it to Automatic go to:

    Formulas (Ribbon tab) >> Calculation >> Calculation Options >> Automatic

     

    I hope this helps you

Jim-1346's avatar
Jim-1346
Copper Contributor
Apr 19, 2019
Sorry Haytham - Just saw the rest of your response - You said it right - but still confused as to how it changes to manual in existing spreadsheets.

Jim
Dan_Sherman's avatar
Dan_Sherman
Copper Contributor
Dec 08, 2020

Jim-1346  I have a similar problem, but the spreadsheet is set on automatic, yet two cells in the spreadsheet will not update.  Even pressing F9 does not do it.  I have to edit each cell to make it update.  Any ideas?