Forum Discussion
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...
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
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
I use a VBA-routine SUMCOLOR to calculate 2 different summary cells (A and B) with values coming from 1 column. Depending on the background fill colour of the cell the value of that cell is either added to summary cell A or summary cell B. Nothing spectacular. All used to go well for almost 4 years and the Calculation Options was always set to Automatic as described above. As from today (November 1st 2021) that automatic update does not work anymore.
When I change the fill background colour of a cell in the column nothing happens. However when I press the "Undo format cell" button in the left upper corner (or Ctrl-Z) and then the "Redo format cell" button (or Ctrl-Y) the summary cell is adjusted as it should have been when changing the fill background colour in the first place.
Am I forgetting something here?
Thanks for your advice.
When I change the fill background colour of a cell in the column nothing happens. However when I press the "Undo format cell" button in the left upper corner (or Ctrl-Z) and then the "Redo format cell" button (or Ctrl-Y) the summary cell is adjusted as it should have been when changing the fill background colour in the first place.
Am I forgetting something here?
Thanks for your advice.