Written and reviewed by FormulaCraft Team. Each formula on this page is run through our verification engine before publishing.
Last reviewed:
Fix the Not calculating error
Excel & Google SheetsWhat Not calculating means
Spreadsheet applications can run in Manual Calculation mode, which means formulas only recalculate when explicitly triggered. The cell shows a stale value — or even zero — because the engine has not re-evaluated the formula since the input data changed.
Common causes
- Calculation is set to Manual (Excel: File > Options > Formulas; Sheets: Tools > Calculation settings), so formulas only update when you press F9.
- The cell or a precedent range is formatted as Text, so the value is stored as a string and is never evaluated by the formula engine.
- A circular reference exists somewhere in the workbook, causing Excel to halt recalculation of the affected chain.
- The workbook contains a very large number of volatile functions (NOW, RAND, OFFSET, INDIRECT) and automatic calculation appears slow or stuck.
- In Google Sheets, iterative calculation is enabled and a formula has converged to a fixed value that no longer reflects current inputs.
Example fix
Broken
=SUM(A1:A5)Fixed
=SUM(A1:A5)The formula itself is correct. The fix is switching calculation mode from Manual to Automatic (or pressing F9). After the mode change the cell immediately reflects the current sum of A1:A5.
Try it with your data
Edit the grid or formula, then run it through a real spreadsheet engine — no signup.
Sample data — click any cell to edit
Runs server-side · free · no signup
How to fix it
- 1In Excel: File > Options > Formulas > Calculation Options > set to Automatic. In Google Sheets: Tools > Calculation > set Recalculation to 'On change'.
- 2Press F9 (Excel) or Ctrl+Shift+F9 (force full recalculation in Excel) to manually trigger a recalculation right now without changing the mode setting.
- 3Check Formulas > Error Checking > Circular References (Excel) and resolve any highlighted circular references, which block the recalculation chain.
- 4Verify the formula cell's number format is not 'Text' — change it to General and press F2 > Enter to re-enter the formula.
- 5If the formula uses INDIRECT or OFFSET, confirm that the referenced range addresses are still valid after any row or column insertions or deletions.
Stop hunting errors by hand.
Upload your spreadsheet and the Auditor flags every Not calculating and broken formula at once — or paste this one formula and get the fix explained.
Frequently asked
How did my workbook end up in Manual Calculation mode?
Excel remembers the calculation mode of the last workbook you had open. If a colleague's file uses Manual mode and you opened it before your own, Excel inherits that setting for the session.
My formula still shows the old value even after pressing F9 — why?
A circular reference prevents the full chain from recalculating. Go to Formulas > Error Checking > Circular References and fix the loop before pressing F9 again.
In Google Sheets, does recalculation mode affect all formulas or just volatile ones?
Volatile functions like TODAY, NOW, and RAND respect the Recalculation setting (on change, on change and every minute, or on change and every hour). Standard formulas always recalculate on data change regardless of that setting.