Forum Discussion

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
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

Haytham Amairah

Silver Contributor

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

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
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?