Excel Formula Not Auto Calculating? How to Fix It

Errors & fixes · Updated November 19, 2026

If an Excel formula is not auto calculating, first check that calculation is set to Automatic: on Windows, go to File > Options > Formulas, then under Workbook Calculation choose Automatic. If the formula still does not update, check whether the cell is formatted as Text, whether Show Formulas is on, and whether the formula itself is valid.

Start with a quick check

Change a value that the formula uses and see whether the result changes. If it does not, select the formula cell and look at the formula bar. A formula should generally begin with an equals sign, such as =SUM(B2:B5). If the cell displays the formula characters instead of a result, that points to a display or text-entry issue. If it displays an old result, calculation mode or a dependency may be the cause.

Use this short sequence to narrow down the problem before editing the workbook:

  1. Check Formulas > Calculation Options and select Automatic.
  2. Press F9 to request a calculation. On a laptop, you may need to hold Fn as well.
  3. Check whether Formulas > Show Formulas is enabled.
  4. Look at the cell’s number format and whether the entry begins with an apostrophe or an extra space.
  5. Confirm that the formula refers to the cells you intended and that those input cells contain current values.

These checks distinguish three different situations: Excel has not recalculated, Excel is showing the formula rather than its result, or the formula has recalculated but returns an unexpected value. Each needs a different fix.

Check Excel’s calculation mode

Excel can calculate formulas automatically or wait for a manual calculation command. If a workbook is in Manual mode, changing an input cell may leave dependent formulas showing their previous results. This can make a correct formula look broken, especially in a large workbook where the setting was changed to speed up calculations.

In Excel for Microsoft 365 on Windows, select File > Options > Formulas. Under Workbook Calculation, select Automatic, then choose OK. You can also use Formulas > Calculation Options > Automatic on the ribbon. Calculation mode can affect other open workbooks too, so check it if a second workbook also seems stuck.

To calculate immediately, press F9. Shift+F9 calculates the active worksheet, while Ctrl+Alt+F9 forces a full calculation of all formulas in open workbooks. If results still seem stale because Excel’s dependency information needs rebuilding, Ctrl+Shift+Alt+F9 forces a full recalculation and rebuilds the dependency tree. These commands recalculate; they do not repair incorrect formula references.

On Mac, open Excel > Settings (called Preferences in some releases) and look for Calculation settings, or use the Calculation Options on the Formulas tab if available. Mac keyboard shortcuts can differ and may require the Fn key; using the ribbon’s calculation commands avoids relying on a Windows shortcut. Excel for the web normally calculates formulas automatically, but a workbook that was saved with Manual calculation settings can behave differently when opened in desktop Excel.

When Excel displays the formula instead of its result

If a cell visibly contains something like =SUM(B2:B5) instead of a number, first check whether Show Formulas is on. Select Formulas > Show Formulas to turn it off. The Windows shortcut Ctrl+` (the grave-accent key, often near the top-left of the keyboard) toggles this view. The display setting affects the worksheet, so several formulas may appear at once when it is enabled.

If only one or a few cells show formula text, they may be stored as text. This often happens when the cell was formatted as Text before the formula was entered, or when the entry has an apostrophe or a leading space before the equals sign. Select the cell, change its number format to General from the Home tab, then press F2 and Enter to make Excel interpret the existing entry again. Changing the format alone may not convert a formula already stored as text.

For example, with values 12, 8, 15, and 5 in B2:B5, a cell formatted as General and containing =SUM(B2:B5) should display 40. If it displays the characters instead, re-enter the formula after correcting the format. If the formula bar shows a leading apostrophe or space, remove it as well. Be careful not to delete a legitimate apostrophe that is part of text in another kind of cell.

Check formula syntax and cell references

A formula will not calculate as intended if it is incomplete or points to the wrong cells. Confirm that it starts with an equals sign, has balanced parentheses, uses the right function name, and includes the intended range. Excel generally highlights parts of a formula as it is edited, which can help reveal an omitted parenthesis or an incorrect reference.

For a simple example, with unit prices in B2:B5 and quantities in C2:C5, the formula =B2*C2 entered in D2 multiplies the price by the quantity on row 2. If B2 is 4 and C2 is 3, the result is 12. Copying that formula down normally changes the references for each row. If you need one reference to stay fixed while copying, use dollar signs, as in =$B$1*C2. With a rate of 5 in B1 and a quantity of 3 in C2, that formula returns 15 and keeps using B1 when copied down.

Argument separators can depend on regional settings. Many installations use commas, but some use semicolons. If Excel rejects a formula copied from a guide, check the separator expected by your Excel installation rather than assuming the calculation engine is broken. Also check whether a formula was pasted as plain text from an email, web page, or document; re-entering it directly in the formula bar can expose hidden spaces or unusual characters.

Trace the inputs and dependencies

A formula only updates from the values and references it actually uses. Select the formula cell and inspect its references in the formula bar. For a complex workbook, use Formulas > Trace Precedents to see which cells feed the selected formula, and Trace Dependents to see which formulas rely on it. These tools can reveal that the formula points to a different sheet, an old range, or a cell that is blank.

Check whether an input that looks numeric is actually text. A number imported from a website or CSV file may be stored as text, sometimes because of spaces or an apostrophe. A function may then return an error or handle it differently from a true number. Likewise, a formula may be correct but intentionally return a blank or zero because of its logic. Inspect the formula’s conditions and the source values before replacing it.

Look for circular references too. A circular reference occurs when a formula refers to itself directly or through a chain of other formulas. Excel may warn about the circular reference, and the result may not be what you expect. If the circular calculation is intentional, iterative calculation must be enabled and configured; otherwise, rewrite the references so the calculation flows from inputs to results without looping.

Know when recalculation is not the same as refreshing

F9 recalculates formulas, but it does not necessarily update every kind of data in a workbook. A formula such as SUM uses values already present in cells. A query, linked data connection, PivotTable, or external source may need its own refresh command before formulas based on that data can show the latest information. For connections, use Data > Refresh All when appropriate, then allow the refresh to finish before judging the formula result.

Some functions also recalculate at particular times or depend on external conditions. A formula that refers to another workbook may rely on that workbook being available and its links being updated. If Excel shows a link or security prompt, resolve it using a trusted source rather than enabling unknown content. A delayed or unavailable connection is different from a formula stuck in Manual calculation mode.

Another common misconception is that every displayed value changes whenever any workbook value changes. A formula updates only when its inputs or relevant calculation conditions change. If the referenced value has not changed, the displayed result may correctly remain the same. Compare the formula bar and its precedent cells before treating an unchanged result as evidence of a failure.

A practical troubleshooting order

For a workbook you need to repair without disrupting other calculations, work from simple checks to more forceful recalculation:

  • Save a copy of the workbook before making broad changes, especially if it contains important or linked data.
  • Check calculation mode and set it to Automatic if that is appropriate for the workbook.
  • Check Show Formulas, cell format, leading spaces, and apostrophes if formula text is visible.
  • Inspect the formula and its precedent cells; correct the reference or syntax if needed.
  • Use F9, then Shift+F9 for the active sheet if you want to recalculate only that sheet.
  • Use Ctrl+Alt+F9 or rebuild dependencies with Ctrl+Shift+Alt+F9 only if ordinary recalculation does not resolve stale results.
  • Refresh data connections separately when the formula depends on imported or external data.

Changing to Automatic can make a large workbook slower if it contains extensive calculations, but it is usually the right setting when users expect results to update as inputs change. Manual mode can be useful for performance, provided users know they must recalculate before relying on the displayed results.

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. Turn off Formulas > Show Formulas; if only one cell is affected, change it to General and re-enter the formula with F2, then Enter.

What key recalculates formulas in Excel?
On Windows, F9 recalculates formulas in open workbooks, and Shift+F9 recalculates the active worksheet. Laptop keyboards may require Fn. On Mac, use the Formulas tab’s calculation commands if the Windows shortcuts do not apply.

Why does my formula update only after I press F9?
The workbook is likely using Manual calculation mode. Set Workbook Calculation to Automatic in Excel’s calculation settings if you want formulas to recalculate when inputs change.

Does changing a cell from Text to General fix a formula?
It can help, but changing the format does not always reinterpret an entry already stored as text. After changing the format, select the cell, press F2, and press Enter to re-enter it.

Why are formulas still out of date after I press F9?
Check whether the formula points to the expected cells and whether its source data is current. Queries and external connections may need a separate refresh, and circular references or broken links require their own corrections.

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.