Excel Cell Won’t Calculate? Fix Formulas That Don’t Update

Errors & fixes · Updated November 18, 2026

If an Excel cell won’t calculate, first check Formulas > Calculation Options > Automatic, then check that the cell is not formatted as text and that Excel is displaying results rather than formulas. These checks fix many cases where a value stays old, a formula appears literally, or a cell seems blank.

Start with the quickest checks

Look at the cell and the formula bar before changing anything. If the cell shows a formula beginning with an equals sign, but the displayed result is old, calculation mode or a dependency may be the issue. If it shows the formula itself, investigate text formatting or Show Formulas. If it is blank, check whether the formula returns an empty string, whether the text color matches the background, and whether the column is wide enough to display the result.

For a basic test, assume A2 contains 12 and B2 contains 8. Enter =A2+B2 in C2; the expected result is 20. If the cell does not show 20, use this short checklist:

  • Confirm the formula begins with an equals sign and has no leading apostrophe.
  • Set calculation to Automatic and recalculate.
  • Set the cell’s number format to General, then re-enter the formula if it was stored as text.
  • Check for an error, a circular reference, or an incorrect cell reference.

Check Excel’s calculation mode

In Excel for Microsoft 365 on Windows, select Formulas > Calculation Options > Automatic. In Automatic mode, Excel recalculates formulas when their inputs change. If the option is set to Manual, a formula can remain visible with an old result even after you edit a value it depends on. Manual calculation is sometimes useful in very large workbooks, but it can make ordinary changes look as if they have not taken effect.

After switching to Automatic, press F9 to recalculate open workbooks. Press Shift+F9 to calculate the active worksheet. If results still seem inconsistent, Ctrl+Alt+F9 forces a full calculation, while Ctrl+Alt+Shift+F9 rebuilds the calculation dependencies and recalculates. These stronger commands can take time in a large file, so allow Excel to finish before judging the result.

On a Mac, use Formulas > Calculation Options to select Automatic where that option is available. Keyboard shortcuts can depend on the keyboard and function-key settings; F9 may require holding Fn. The Formulas tab also includes Calculate Now and Calculate Sheet commands. Excel for the web normally recalculates formulas automatically, but it does not expose every desktop calculation control. If a workbook behaves differently in the browser, open it in the desktop app to inspect its calculation settings.

Fix formulas stored as text

A cell formatted as Text can treat a newly entered formula as ordinary characters instead of calculating it. This often happens when a column was formatted before data was pasted, or when a leading apostrophe was used to preserve an entry. The formula may appear in the grid exactly as typed, with no result.

Select the affected cells, then choose Home > Number Format > General. Changing the format alone may not convert a formula that Excel has already stored as text. To make Excel interpret it again, select each affected cell, press F2, and then press Enter. For a large range, the Text to Columns command can sometimes reprocess entries, but check a copy or a small sample first because it can alter data.

Also inspect the beginning of the cell’s contents. An apostrophe before the equals sign, or a space before it, can prevent Excel from recognizing the entry as a formula. Remove the extra character and confirm that the first meaningful character is the equals sign. Pasted content may include invisible spaces or other characters, so retyping one formula in a clean cell is a useful diagnostic.

Make sure Excel is showing results

When Show Formulas is on, Excel displays formulas in worksheet cells instead of their calculated results. On Windows, press Ctrl+grave accent (the key usually just below Esc) to toggle this view, or select Formulas > Show Formulas. On a Mac, the keyboard shortcut may vary by keyboard layout; use the Show Formulas command on the Formulas tab if the shortcut does not work.

In this view, formulas may make columns look unusually wide because the formula text takes more room than a number. Turning Show Formulas off should restore the results, provided the cells are calculating normally. This is a display setting, not a change to the formulas themselves.

A result may also be present but hard to see. A narrow column can show hash marks for some number formats, and a custom number format can hide values. Select the cell and look at the formula bar; then try a standard format such as General or Number. If the formula bar shows an error or an unexpected value, the problem is calculation rather than visibility.

Check the formula and its references

Excel cannot produce the intended answer if the formula points to the wrong cells or uses an invalid expression. Check that the referenced cells contain the values you expect, that ranges include all relevant rows, and that parentheses and quotation marks are paired. A copied formula may also shift references as it is filled down; dollar signs make a reference absolute when it should stay fixed. Use the formula bar to inspect the expression, and select a referenced cell to confirm its contents.

For a simple total, assume B2, B3, and B4 contain 10, 15, and 5. Enter =SUM(B2:B4) in B5; the expected result is 30. If the result is 25, one of the referenced values or the range may differ from the example. If it is zero, verify that the entries are numbers rather than text. A green triangle or a warning in the cell may offer a useful hint, but inspect the underlying values rather than relying only on the warning.

Errors such as #VALUE!, #REF!, #NAME?, and #DIV/0! mean Excel did calculate something, but the formula encountered a problem. For instance, #REF! often points to a reference that was deleted or became invalid, while #NAME? can indicate an unrecognized function name or misspelled name. Read the error, inspect the formula, and correct the cause; hiding the error with an error-handling function does not repair incorrect inputs.

Look for circular references and dependency issues

A circular reference occurs when a formula depends on its own result, either directly or through another cell. For example, a total formula placed inside the range it is meant to add can create a loop. Excel may display a circular-reference warning, or the result may not behave as expected. On Windows, inspect Formulas > Error Checking > Circular References for listed cells, then revise the formula or move it outside the range it totals.

Excel can support intentional circular calculations when iterative calculation is enabled, but that setting is for specific models and requires deliberate choices about iteration limits and acceptable change. Do not enable it just to silence a warning. First determine whether the loop is intentional; most everyday circular references are caused by a misplaced total or a formula that points back to itself.

In complex workbooks, one cell may depend on several intermediate formulas. If an upstream cell contains text, an error, or an old value, the final result can appear wrong even though the final formula is valid. Trace the inputs one step at a time, and use Formulas > Trace Precedents or Formulas > Trace Dependents to inspect relationships. A full recalculation can help if the dependency chain itself seems stale, but it will not fix a wrong reference.

Separate formula calculation from data refresh

Not every value in a workbook comes from an ordinary cell formula. PivotTables, Power Query results, linked workbooks, and data connections may need their source data refreshed. Pressing F9 recalculates formulas; it does not necessarily retrieve new records from an external source. For supported connections, use Data > Refresh All and wait for the refresh to complete. If the result remains unchanged, check the connection, credentials, permissions, and source data.

External workbook links can also refer to a file that has moved, been renamed, or is unavailable. Excel may ask whether to update links when the workbook opens. Confirm that the source file is the intended one before updating; if the link is broken, locate or repair the source rather than assuming a calculation command will restore it. A formula can recalculate correctly and still return an old or unavailable linked value.

Consider function and version compatibility

A workbook created in a newer Excel version may use a function that an older copy cannot calculate. In an unsupported version, a formula may display a #NAME? error or an _xlfn. prefix. XLOOKUP, FILTER, SORT, UNIQUE, SEQUENCE, and LET require Excel 2021 or Microsoft 365; functions such as TEXTSPLIT, TEXTBEFORE, TEXTAFTER, VSTACK, and HSTACK require Microsoft 365 or Excel 2024. If you share a workbook with someone using an older release, check compatibility or provide an alternative formula they can use.

Formula argument separators can also depend on regional settings. Excel commonly uses commas, but some configurations use semicolons in formulas. If a formula copied from a website is rejected despite appearing correctly formed, check your locale’s separator convention and the function’s spelling. This is a syntax issue, not evidence that calculation is turned off.

A reliable troubleshooting order

Work from the least disruptive checks to the more involved ones. This makes it easier to find the cause without changing unrelated workbook settings:

  1. Check whether the cell shows a result, formula text, or an error, and inspect the formula bar.
  2. Turn off Show Formulas if the worksheet is displaying expressions.
  3. Set calculation to Automatic, then recalculate the sheet or workbook.
  4. Check the cell format, leading characters, formula syntax, and referenced values.
  5. Investigate circular references, broken links, or data that needs refreshing.
  6. Check whether the workbook uses functions unavailable in the installed Excel version.

If only one workbook behaves oddly, save a separate copy before making major changes. If every workbook is affected, check Excel’s calculation setting and whether a particular add-in or external data process is involved. When a file contains important business data, keep the original unchanged until you understand what caused the stale result.

Frequently Asked Questions

Why does Excel show the formula instead of the answer?
Show Formulas may be enabled, or the cell may be formatted as Text or contain a leading apostrophe. Toggle Show Formulas off, set the cell to General, and re-enter the formula if necessary.

Why does my Excel formula update only when I press F9?
The workbook may be in Manual calculation mode. Choose Formulas > Calculation Options > Automatic. If Automatic is already selected, inspect dependencies and consider whether a linked source or data connection needs refreshing.

Does changing a cell from Text to General fix the formula by itself?
Not always. The format change affects future entries, but a formula already stored as text may need to be re-entered. After changing the format, press F2 and Enter on the cell to have Excel interpret its contents again.

Why does Excel show a blank result even though there is a formula?
The formula may intentionally return an empty string, or a custom number format may hide the value. Check the formula bar and temporarily apply General format. Also check whether the result is white text on a white background or the column is too narrow.

Will F9 refresh a PivotTable or Power Query data?
Not necessarily. F9 recalculates formulas, while external data and PivotTables may require a refresh. Use Data > Refresh All for supported connections, and check that the source is available and current.

Related

Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.

More in Errors & fixes

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.