Excel Formulas Not Updating Automatically? Fix It

Errors & fixes · Updated November 18, 2026

If Excel formulas are not updating automatically, set calculation to Automatic: go to Formulas > Calculation Options > Automatic. If that does not fix it, check whether the formula is stored as text, whether Excel is displaying formulas instead of results, and whether the formula actually refers to the changed cells.

Why Excel formulas sometimes stop recalculating

Excel normally recalculates formulas when a value they depend on changes. For example, if a total in D2 adds the values in B2 and C2, editing either input should update the total. This behavior depends on the workbook’s calculation setting. In Automatic mode, Excel recalculates dependent formulas as needed; in Manual mode, it waits for you to request a calculation.

Manual calculation can be useful in large or complex workbooks, where recalculating after every edit causes a delay. It is also easy to switch on accidentally, or to inherit when opening a workbook created with that setting. A cell that appears out of date is not always a calculation problem, though. The formula may point to the wrong range, be stored as text, or rely on data that has not been refreshed.

Set calculation to Automatic

In Excel for Microsoft 365 on Windows, open the workbook and choose Formulas > Calculation Options > Automatic. Make a small change to an input cell and see whether the result updates. If the option already says Automatic, continue with the checks below rather than repeatedly toggling it.

Calculation mode can affect other workbooks that are open in the same Excel session. If you work with several files, a workbook set to Manual may make results in another open workbook seem stale too. After changing the setting, check important workbooks and save them when their formulas show the expected results. The setting is not a substitute for refreshing imported data or checking formula references.

On Excel for Mac, the calculation setting is also available from Formulas > Calculation Options; choose Automatic. Ribbon layout can vary slightly by release. Excel for the web generally recalculates formulas automatically and does not expose all the same desktop calculation controls, so if the problem occurs only in the browser, check the formula, its references, and whether the workbook needs a data refresh.

Force a calculation and see what changes

If you have restored Automatic mode but a result still looks old, ask Excel to calculate explicitly. On Windows, press F9 to calculate open workbooks, or Shift+F9 to calculate the active worksheet. If dependent results still appear stale, Ctrl+Alt+F9 forces a full calculation of formulas. Laptop function-key settings may require holding Fn as well.

On a Mac, function keys may need Fn, depending on macOS keyboard settings. You can also use the calculation commands on the Formulas tab instead of relying on a shortcut. Treat a forced calculation as a diagnostic: if it fixes the displayed value, the calculation mode or recalculation state was likely involved. If it does not, inspect the formula and the cells it uses.

For a quick test, assume the price is in B2 and the quantity is in C2. With 12.5 in B2 and 4 in C2, the formula in D2 is =B2*C2, which should return 50. If changing C2 to 5 leaves D2 at 50, check calculation mode first. If D2 changes to 62.5, calculation is working; the original issue may be elsewhere in the workbook.

Check that the cell contains a formula, not text

A formula-looking entry may be plain text. This can happen if the cell was formatted as Text before the formula was entered, or if the entry begins with an apostrophe or an unintended space. In that state, Excel displays something like =B2*C2 as characters rather than calculating it. Changing the cell’s format to General alone may not convert an existing text entry into a working formula.

To check and repair one cell:

  1. Select the cell and inspect the formula bar. If the formula appears as text in the cell itself, or has a leading apostrophe, it may not be an active formula.
  2. Set the cell format to Home > Number Format > General.
  3. Enter edit mode by pressing F2 on Windows, then press Enter. On a Mac, use the equivalent edit command or double-click the cell, then confirm the entry.

If an entire column of formula entries is text, select the affected cells, change the format to General, and re-enter the formulas. For a large range, Excel’s Data > Text to Columns tool can sometimes convert text-formatted values, but check a small sample first: it is easy to alter data unintentionally. A formula should begin with an equals sign and use valid Excel syntax.

Make sure Excel is showing results, not formulas

If many cells display entries such as =SUM(A1:A5) instead of numeric results, the worksheet may be in Show Formulas view. This setting changes what is displayed; it does not mean the formulas have stopped calculating. Choose Formulas > Show Formulas to turn the view off. On Windows, Ctrl+` toggles this display; the backtick key is usually near the upper-left area of the keyboard. Keyboard layouts differ, so the ribbon command is a reliable alternative.

Also inspect the number format if a formula seems to return an unexpected result. A date, percentage, or custom format can make a correct underlying value look surprising. If the cell displays ####, Excel may simply lack enough column width to show the formatted value; widen the column before assuming the formula failed. Formatting changes appearance, not the calculation itself.

Verify the formula’s references and dependencies

Excel can only recalculate what a formula actually references. If a total uses a fixed range that stops above a newly added row, changing the new row will not affect the result. Likewise, a formula that points to a different sheet, an old cell, or a hard-coded number may be calculating correctly while failing to reflect the value you expected it to use.

Select the result cell and inspect its formula in the formula bar. Click or edit the formula to review the colored reference outlines, then confirm that the changed input is included. Check for absolute references, shown with dollar signs, such as $B$2: these keep a reference fixed when a formula is copied. That behavior is often intentional, but it can surprise you if you expected a copied formula to move to the next row.

For a complicated formula, use Formulas > Evaluate Formula to step through its calculation. This can reveal an unexpected intermediate value or a reference to the wrong cell. Be careful when using Find and Replace to change formula references across a workbook; it can alter formulas you did not intend to touch. If formulas use a table, confirm that the new record is actually part of that table and that the formula’s structured reference includes the relevant rows.

Look for circular references and calculation exceptions

A circular reference occurs when a formula depends, directly or indirectly, on its own result. For example, a formula in B5 that adds B1:B5 includes itself. Excel may display a circular-reference warning, and iterative calculation settings can affect how such a workbook behaves. Unless the workbook is deliberately designed to use iteration, correct the reference so the formula does not include its own cell.

Excel can help identify a circular reference through the status bar or the circular-reference options under Formulas > Error Checking. The exact indication depends on the workbook and version. Do not turn on iterative calculation simply to hide a warning: it changes how Excel handles circular formulas and can make results depend on iteration settings. First determine whether the loop is intended and understand the workbook’s design.

Some specialized features also have their own calculation behavior. What-If Analysis data tables, for instance, have a separate calculation option under Formulas > Calculation Options. If ordinary formulas update but a data table does not, inspect that option as well as the main Automatic or Manual setting. A workbook with macros may also contain code that changes values or calculation settings; review its behavior before assuming Excel’s standard formula calculation is responsible.

Distinguish formula recalculation from data refresh

A formula and the data it uses are separate things. A formula such as a sum can recalculate immediately while still using old values imported from a text file, database, Power Query, or another workbook. Recalculation does not necessarily retrieve new information from those sources. For a query or connection, use the workbook’s refresh command, commonly Data > Refresh All, and check the connection’s refresh settings if data remains old.

External workbook links are another distinct case. A formula that refers to another file may depend on that file being available and on Excel updating links. If a link-update prompt appears, review the source and choose whether to update it; do not enable updates from an unfamiliar file without checking its origin. A displayed value can also be the last saved result if the source workbook is closed or unavailable. That is different from a local formula failing to recalculate.

This distinction is useful when only certain results are stale. If local calculations change but imported rows do not, refresh the source data. If values update after pressing F9 but query results remain old, address the connection. If neither changes, inspect calculation mode, formula text, and references in that order.

Prevent the same issue in future workbooks

Manual calculation can improve responsiveness in a workbook with many formulas, but it creates a risk: results can look final while still reflecting earlier inputs. If you intentionally use Manual mode, make the setting visible to anyone who uses the file and calculate before saving or sharing. Check key totals after changes rather than assuming every dependent value refreshed.

For everyday workbooks, Automatic is usually the clearer choice. To reduce unnecessary recalculation without switching the whole workbook to Manual, simplify formulas, avoid oversized references when practical, and remove duplicate calculations where possible. Before distributing a workbook, test a known input change, confirm important outputs, and refresh external data where appropriate. Saving a file does not guarantee that its external connections have been refreshed.

Frequently Asked Questions

Why does Excel only update formulas when I press F9?

The workbook is likely using Manual calculation, or Excel has not recalculated a dependency. Choose Formulas > Calculation Options > Automatic, then test an input. If Automatic is already selected, check whether the formula refers to the changed cell and whether that input is stored as a number or text.

Why does changing a cell not change my formula result?

Check that the formula references the cell you edited, that the formula is not stored as text, and that calculation is Automatic. If the formula relies on imported or linked data, refresh the data source separately. These checks identify the most common differences between a calculation issue and an input or reference issue.

Why are formulas showing instead of their answers?

Turn off Formulas > Show Formulas. If only one cell shows a formula as text, change its format to General and re-enter the formula. Show Formulas is a worksheet display mode; a text-formatted cell is a separate problem.

Does pressing F9 refresh Power Query or linked data?

F9 recalculates formulas; it is not the same as refreshing a query or connection. Use Data > Refresh All for supported external data, and review link prompts for external workbook references. A refreshed formula cannot produce current results from source data that remains old.

Why does one workbook affect calculation in another?

Calculation mode can apply across workbooks open in the same Excel session. If one file is set to Manual, check the setting after opening the other workbook too. Use Automatic for ordinary work, or deliberately manage and communicate Manual mode when performance requires it.

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.