If an Excel formula is not calculating, the cause may be manual calculation mode, a formula stored as text, an unexpected reference, a circular reference, an unavailable external workbook, or a worksheet setting that changes how formulas are displayed. Work through the checks in order and change one thing at a time so you can identify the real cause.
1. Check whether Excel is in Manual Calculation mode
When calculation mode is manual, formulas may not recalculate automatically after source values change. In Excel, open Formulas → Calculation Options and confirm that the intended workbook calculation mode is selected. Microsoft identifies Automatic calculation as the normal setting for immediate recalculation. Microsoft: avoid broken formulas.
2. Check whether Show Formulas is turned on
If many cells display expressions such as =SUM(A1:A10) instead of results, the worksheet may simply be showing formulas. Microsoft documents the Show Formulas command and the Ctrl + ` shortcut for switching between formula display and calculated results. Microsoft: Show and print formulas.
3. Check whether the formula cell is formatted as Text
A formula entered into a Text-formatted cell can be treated as text instead of being evaluated. Change the cell to an appropriate number/general format and re-enter or confirm the formula when necessary. Microsoft lists text formatting as a common reason a formula displays instead of calculating. Microsoft formula guidance.
4. Check for a leading apostrophe
An apostrophe before a formula tells Excel to treat the entry as text. Look at the formula bar and remove the apostrophe when it was added accidentally.
5. Check the formula and cell references
Look carefully at parentheses, operators, function names, worksheet names and ranges. A formula can be syntactically valid and still reference the wrong cells. For copied formulas, confirm whether relative references moved as expected.
6. Check numbers stored as text
Values that look like numbers may actually be text. That can cause arithmetic or lookup formulas to behave unexpectedly. Check the cell format and use a small test calculation to confirm that Excel is treating the value as numeric data.
7. Check for circular references
A circular reference occurs when a formula depends directly or indirectly on itself. Excel can identify circular-reference conditions, and the resulting calculation may not be what you intended. Review the dependency path instead of hiding the symptom with error-handling functions.
8. Check external workbook links
If a formula depends on another workbook, an unavailable or changed external source can affect the result. Confirm that the linked file exists and that the formula still points to the intended workbook and range.
9. Recalculate after fixing the cause
Once the calculation settings and formula are correct, recalculate the workbook and compare the result with an independently calculated sample. Recalculation is useful for verification, but it is not a substitute for correcting a broken reference or text-formatted input.
10. Check inconsistent formulas in a copied range
A single formula can differ from the neighboring pattern because a reference was changed accidentally. Microsoft recommends using Show Formulas and comparing the inconsistent formula with adjacent formulas when investigating inconsistent patterns. Microsoft: fix an inconsistent formula.
Use error-handling functions carefully
IFERROR and similar functions can make a worksheet look cleaner, but they can also hide a real calculation problem. Use error handling when the error is an expected condition with an intentional fallback—not simply to make a broken formula disappear.
When the workbook itself may be damaged
If unrelated formulas behave unexpectedly across the workbook, make a copy before attempting recovery. Avoid editing many formulas at once. Use Excel's supported recovery or repair features when appropriate.
Practical troubleshooting sequence
- Check Calculation Options.
- Check Show Formulas.
- Check Text formatting and leading apostrophes.
- Inspect the formula syntax and references.
- Check numbers stored as text.
- Check circular references and external links.
- Recalculate.
- Compare the result with a simple independent calculation.
Quick checklist
- □ Automatic calculation is selected when required.
- □ Show Formulas is not hiding the normal results view.
- □ Formula cells are not accidentally formatted as Text.
- □ References and ranges are correct.
- □ Numbers are stored as numbers when required.
- □ Circular and external references are understood.
- □ Important results were independently checked.
Quick answer
When an Excel formula is not calculating, first check calculation mode and Show Formulas, then look for Text formatting, leading apostrophes, incorrect references, text-formatted numbers, circular references and unavailable external links. Microsoft documents these as common formula troubleshooting areas. Microsoft formula troubleshooting.