Not Calculating
Microsoft Microsoft Excel
Severity: ModerateWhat Does This Error Mean?
Excel stops calculating when the calculation mode is switched to Manual. This means formulas don't update when you change data. It's a one-click fix in the Formulas tab.
Affected Models
- Microsoft Excel 2019
- Microsoft Excel 2021
- Microsoft 365 Excel
- Excel for Windows
Common Causes
- Calculation mode is set to Manual instead of Automatic — formulas won't update until you press F9
- Cell is formatted as Text, so Excel treats the formula as a typed string, not a calculation
- A circular reference is blocking the calculation chain (a formula that refers back to itself)
- A formula error like #VALUE or #REF is stopping dependent calculations from completing
- The worksheet is protected, preventing Excel from updating cell values
How to Fix It
-
Go to the Formulas tab at the top, click 'Calculation Options', and select 'Automatic'.
If it was set to Manual, this is your fix. All formulas will immediately recalculate.
-
Press F9 on your keyboard to force Excel to recalculate everything right now.
F9 is a manual recalculate shortcut — useful when you're in Manual mode or want to check if calculation is the issue.
-
Click the cell with the formula that's showing as text. Look at the format box (top-left of screen) — if it says 'Text', change it to 'General', then press Delete and retype the formula.
A cell formatted as Text will display a formula like =A1+B1 as plain text instead of calculating it.
-
Check for a circular reference warning at the bottom of Excel. Go to Formulas > Error Checking > Circular References to find and fix it.
A circular reference means a formula is referencing its own cell, which creates an endless loop and stops calculation.
-
Check if the sheet is protected: Review tab > Unprotect Sheet. If prompted for a password, ask whoever protected it.
A protected sheet prevents Excel from writing new calculated values to cells.
When to Call a Professional
Formula and calculation issues are something you can fix yourself. All fixes are done within Excel — no IT professional needed.
Frequently Asked Questions
Why is my Excel formula showing as text instead of a result?
The cell is formatted as Text, so Excel treats everything in it as a label — not a formula. Change the cell format to General, then delete and retype the formula.
What does it mean when Excel says there's a circular reference?
A circular reference means a formula is referring back to its own cell, directly or through a chain. Excel can't calculate this without going in circles, so it stops and warns you instead.
Why does pressing F9 fix the problem but formulas stop updating again later?
Your Excel is stuck in Manual calculation mode. Go to Formulas > Calculation Options > Automatic to make formulas update themselves whenever data changes.