Formula guide · Excel · Updated May 13, 2026
Excel Formula Not Calculating
Fix Excel formulas that do not update because calculation mode is manual, cells are formatted as text, or references are stale.
Quick Answer
If Excel formulas are not calculating, switch calculation mode to Automatic and then check whether the formula cell is formatted as Text.
Copyable Formula
Formulas > Calculation Options > AutomaticSyntax
Check Formulas > Calculation Options, cell format, and formula entry.Excel
Worked Example
| Symptom | Likely cause |
|---|---|
| Old result stays visible | Manual calculation mode |
| Formula text is visible | Cell formatted as Text |
| One workbook behaves oddly | Workbook-level calculation setting |
Result: Automatic calculation and properly formatted formula cells restore normal updates.
Steps
- Open the Formulas tab and check Calculation Options.
- Set calculation to Automatic.
- Press F9 to force recalculation if needed.
- Check whether affected cells are formatted as Text.
Common Mistakes
- Assuming Excel is broken before checking calculation mode.
- Fixing one cell while the workbook remains in manual mode.
- Ignoring formulas pasted from external systems as text.
Excel vs Google Sheets Notes
This page is focused on Excel. If you need Google Sheets compatibility, check whether your Sheets account supports the same function or use one of the related alternatives.
Editorial check: This guide was last updated May 13, 2026. Formula behavior can vary by Excel version, Google Sheets rollout, and spreadsheet locale.