If an Excel formula is not updating when its input values change, first check Formulas > Calculation Options > Automatic. If calculation is already automatic, check whether the formula is stored as text, whether its inputs are real numbers, and whether the change requires refreshing an external data source rather than recalculating a formula.
How Excel updates formulas
Excel normally recalculates formulas when a cell they depend on changes. For example, with 10 in A2, 5 in B2, and a formula in C2, enter =A2+B2 in C2. The result is 15; if A2 changes to 12, Excel should show 17. Excel tracks these relationships so it can update dependent cells without recalculating every formula after every edit.
That process is called calculation. It is different from refreshing imported data, such as a Power Query table, and from updating links to another workbook. Knowing which kind of update is missing helps narrow the cause: a formula that refers to ordinary worksheet cells should usually respond to recalculation, while a query may need a refresh.
Check calculation mode first
In Excel for Microsoft 365 on Windows, open the Formulas tab, choose Calculation Options, and select Automatic. In Automatic mode, Excel recalculates dependent formulas when their inputs change. If the workbook is set to Manual, values can change while formula results remain at their previous values until you request a calculation.
To recalculate without changing the setting, press F9 to calculate formulas in all open workbooks, or Shift+F9 to calculate the active worksheet. For a full calculation of all formulas, including ones Excel might not consider changed, press Ctrl+Alt+F9. On a Mac, use the Formulas tab’s calculation controls where available; F9 and Shift+F9 may require the Fn key depending on keyboard settings. Excel for Mac also provides the setting under Excel > Settings (called Preferences in some releases) > Calculation.
Excel for the web also has calculation controls on the Formulas tab, although available options can depend on the workbook and browser version. If a workbook is shared, changing its calculation mode can affect other people working with it. After setting Automatic, edit an input cell and confirm that the result changes before continuing to troubleshoot.
Tell a formula from text
A formula will not calculate if Excel has stored it as text. This often happens when a cell was formatted as Text before a formula was entered, or when an apostrophe was typed before the equals sign. A cell containing '=A2+B2 displays the characters rather than evaluating them. A leading apostrophe may not be obvious in the cell display, so inspect the formula bar as well.
To fix a text-formatted formula, select the cell, change its number format to General from Home > Number Format, then press F2 and Enter to make Excel re-read the entry. Simply changing the format may not convert an existing text entry; re-entering it is the important step. Also check that the formula begins with an equals sign and that Show Formulas has not been turned on. On Windows, press Ctrl+` (the grave-accent key, usually beside 1) to toggle formula display; on Mac, the corresponding shortcut is commonly Control+`. The menu option is on the Formulas tab.
Check whether the inputs are numbers
Values that look numeric may actually be text. This can happen after importing a CSV, copying data from a website, or entering a number with an unexpected space or apostrophe. A formula such as addition may still appear to work with some text values, while comparisons, sorting, or other calculations behave differently than expected. Look for the warning indicator in a cell, check alignment and number format, and try selecting the value to see whether Excel offers a conversion option.
With text value 12 in A2, enter =VALUE(A2) in B2; the result is numeric 12. This can be useful when a value is stored as number-like text, but it will not fix every import issue: stray spaces, unusual separators, or regional decimal conventions may need cleaning first. For a range, use Excel’s available convert-to-number warning or clean the source data, then verify the results with a simple test calculation.
Look for hidden references and formula errors
Sometimes a formula is updating correctly but does not refer to the cell you think it does. Select the formula cell and inspect the formula bar. Check for an incorrect row or column, a fixed reference marked with dollar signs, or a range that stops before the newly added data. For instance, a total using a fixed range will not automatically include new rows typed just below that range.
Also inspect any cells that feed into the result. If an upstream formula contains an error such as #VALUE!, #REF!, or #N/A, dependent formulas may show an error or an unexpected result rather than the number you expect. Use Formulas > Trace Precedents to show cells used by the selected formula, and Formulas > Evaluate Formula to step through its calculation. These tools are especially helpful in long formulas and workbooks with multiple sheets.
Distinguish recalculation from refreshing data
Formulas that refer to ordinary cells recalculate; imported data does not necessarily fetch new information just because a worksheet formula recalculated. If a table comes from Power Query, a text file, a database, or another connection, use Data > Refresh All to request updated source data. Refresh settings and permissions can affect whether that request succeeds, and some sources may require a sign-in or network connection.
Links to another workbook are a separate case. A formula referencing a closed workbook may show the last saved source value until Excel updates the link. Check the workbook’s link-update prompt and the available link controls under Data; do not enable updates from a source you do not trust. If the source workbook is open but its own formulas are not current, recalculate and save the source before relying on linked results.
Consider circular references and special calculation settings
A circular reference occurs when a formula depends on its own result, directly or through a chain of cells. For example, a formula in A1 that refers to B1 is circular if B1 also depends on A1. Excel may warn about the reference or display a result that does not behave as expected. Use the circular-reference information under Formulas > Error Checking to locate the cells and correct the logic.
Some specialized models intentionally use iterative calculation to handle circular references. That setting is not a general remedy for stale results: enabling it can change how a model calculates and may affect accuracy. Only use iterative calculation when the workbook is designed for it and its maximum iterations and change limits are understood. For ordinary budgets, schedules, and lists, removing the circular reference is usually the clearer fix.
Use a reliable troubleshooting sequence
Work through these checks in order, changing one thing at a time. This makes it easier to identify the actual cause instead of masking it with a forced recalculation.
- Confirm the formula cell contains a formula, not text, and that Show Formulas is off.
- Set calculation to Automatic, then edit an input cell or press F9.
- Inspect the formula bar and verify the references include the cells that changed.
- Check input cells for text-formatted numbers, spaces, or upstream error values.
- If the values come from a query or another file, refresh the connection or update the trusted link.
- If the result remains wrong, use Trace Precedents and Evaluate Formula to follow the calculation.
For a controlled test, use a blank area of the worksheet. With 2 in A1 and 3 in B1, enter =A1+B1 in C1; it should return 5. Change A1 to 4 and expect 7. If this simple formula updates but the original does not, Excel’s basic calculation is working and the issue is more likely in the original formula, its inputs, or a connected data source.
Frequently Asked Questions
Why does Excel only update after I press F9?
That usually means calculation is set to Manual, or the workbook needs a full recalculation. Set Formulas > Calculation Options > Automatic, then check whether the result updates after an input changes.
Why does my formula show as text instead of a result?
The cell may be formatted as Text, the entry may begin with an apostrophe, or Show Formulas may be on. Change the format to General, re-enter the formula, and check the Show Formulas control.
Why does Excel not include new rows in my total?
The formula’s range may end above the added rows. Inspect the range in the formula bar and extend it, or use an Excel Table so formulas and structured ranges can adapt as rows are added.
Does recalculating update Power Query data?
No. Recalculation updates formulas based on the data already present. To fetch new query data, use Data > Refresh All and resolve any connection or sign-in prompts.
Will changing Manual to Automatic affect every workbook?
Calculation mode can apply across open workbooks, and workbooks can retain calculation settings. Check the mode after opening another file, especially when working with a shared or complex workbook.
Related
- Excel Dependent Drop-Down Lists: Setup and Fixes
- Excel DOS Keyboard Shortcuts: What Actually Works
- Excel Direct Access vs Link: What’s the Difference?
Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.
More in Errors & fixes
- Word Mail Merge From Excel: Fix Number FormattingIn Word for Microsoft 365 on Windows, format a merge field with a numeric picture switch—for example, {…
- Excel Table Design Tab Missing? How to Find It AgainIf the Excel Table Design tab is missing, click a cell inside the table: the tab is contextual…
- Average Function in Excel Not Working? Fix the CauseIf Excel’s AVERAGE function is not working, first check that the range contains numbers Excel recognizes and that…
- Why XLOOKUP Is Not Working in Excel: Causes and FixesXLOOKUP usually fails because Excel does not support the function, the lookup and return ranges do not line…
- Excel Named Range Error? Causes and FixesAn Excel named range error usually means the name is invalid, unavailable in the current worksheet or workbook,…
- Excel #DIV/0! Error: Causes, Fixes, and PreventionTo get rid of #DIV/0! in Excel, fix the calculation so its divisor is not zero or blank;…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.