Apr 06 2018 11:11 AM
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 the formula bar and hit enter.
The only thing I can recall that I did recently to this spreadsheet was Check for issues > Inspect workbook. Could that have caused it?
Apr 06 2018 11:21 AM
SolutionHi 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
Apr 19 2019 07:14 PM
Apr 19 2019 07:16 PM
Dec 08 2020 08:50 AM
@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?
Nov 01 2021 03:45 AM
Apr 06 2018 11:21 AM
SolutionHi 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