DeskPlainIf the result is stale, choose Formulas > Calculation Options > Automatic. If you see the formula itself, check Show Formulas, then change only the affected cell to General and re-enter it. A visible error needs its own diagnosis.
A formula that will not update is different from a formula returning the wrong total. Start by looking at the cell and its formula bar. Save a working copy before changing formats or calculation settings across a shared report.
The two-minute starting check
In a blank cell, enter =2+3. If it returns 5, calculation works in that cell. Next, select one problem cell and read its actual contents in the formula bar. Compare one input against a value you can calculate yourself. This separates a workbook-wide setting from a local formula or data problem.
| What you see | Start here |
|---|---|
| An old answer after inputs change | Calculation mode |
| The literal =SUM(...) text | Show Formulas or text storage |
| #NAME?, #REF!, or #VALUE! | Syntax, supported functions, references, and input types |
| ##### | Widen the column first; this is not necessarily a failed formula |
Check 1: Recalculate a stale result
Choose Formulas > Calculation Options > Automatic. Use Calculate Now to test an existing formula. In desktop Excel this setting can affect other open workbooks, so consider colleagues' intentional manual models. Microsoft documents the calculation settings; web settings apply to the current workbook.
Check 2: Turn off Show Formulas
If many formula cells suddenly display expressions, toggle Formulas > Show Formulas. That changes the view, not the calculation. Do not overwrite working expressions with their answers just to hide them.
Check 3: Re-enter a formula stored as text
Inspect for a leading apostrophe, spaces before the equals sign, or a missing =. For a cell intended to calculate, choose General format, edit the formula, and press Enter; Windows desktop also supports F2 then Enter. Changing the format alone may leave existing text unchanged. Test one cell before converting a range.
Check 4: Inspect numeric inputs stored as text
Suppose B2 and B3 contain imported amounts 12 and 8 but SUM returns 12. Inspect B3 rather than replacing SUM. Use an available Convert to Number alert only for genuine quantities, or test =VALUE(B3) in a helper column. Preserve product codes and long identifiers as text. Microsoft explains this conversion.
Check 5: Verify ranges and copied references
For ten orders in rows 2–11, =SUM(C2:C10) misses the final order. Inspect the first and last included cells. When a copied formula needs a fixed rate in F1, check whether its reference should be $F$1. A plausible result can still come from the wrong row.
Check 6: Find an accidental circular reference
A total in C12 must not include C12 itself. In desktop Excel, inspect Formulas > Error Checking > Circular References and correct the dependency. Do not enable iterative calculation merely to silence a warning. Use desktop tracing if web controls are insufficient.
Check 7: Check syntax and the actual error
Match parentheses, quotes, and your installation's argument separator. A comma-based example may require semicolons. Treat #REF! as a reference problem and #DIV/0! as a denominator problem; wrapping everything in IFERROR can hide the cause. Microsoft's troubleshooting checklist covers these distinctions.
Check 8: Confirm function compatibility
A shared workbook may use a newer function. XLOOKUP does not work in Excel 2016 or 2019. Identify the recipient's edition before replacing it with a compatible approach. Our Excel Formula Builder supplies starting formulas, but you still need to check the ranges and expected answer in your own workbook.
Keep these in mind
- Identify stale results, displayed text, and errors separately.
- Check one known input and expected answer before changing an entire range.
- Confirm the function exists in the Excel edition used by every recipient.
Common questions
Why does changing Text to General not fix the formula?
The existing entry can remain text. After selecting General, edit and confirm the intended formula again. Try one cell first.
Should I set every formula error to zero?
No. A zero can be a valid value and can hide missing inputs or invalid references. Diagnose the error before adding an intentional fallback.
Sources & further help
Prepared with AI assistance from the linked documentation. This is a source-led explanation, not a claim of hands-on testing across every device. Read the editorial policy.