Fix Excel Formulas Not Updating with Automatic Calculation
Question details
Excel formula results remain unchanged until the formula cell is edited and Enter is pressed, even though automatic calculation is enabled.

- Product
- Microsoft Excel for Microsoft 365
- Device & OS
- not provided
- Scenario
- A user expects formula results to update automatically when workbook data changes.
- Observed behavior
- Formula cells show unchanged results until the user edits each cell and presses Enter.
Open the affected workbook and identify a formula cell and its input cells. Change an input value to confirm whether the formula result updates automatically.
Check calculation settings and circular references
Use this first to confirm automatic calculation is active and find formulas that refer back to themselves.
In Excel, select Formulas > Calculation Options > Automatic. If Automatic is already selected, continue to the next step.
Select Formulas > Error Checking > Circular References. If cell references appear, select each one and review its formula for a reference to itself, directly or through other cells.
Edit any unintended circular formula, press Enter, and change an input cell to check whether the result updates.

Force a full recalculation and check workbook links
Use this when calculation is set to Automatic but results still appear stale.
Convert formulas stored as text back to formulas
Use this if a cell displays a formula instead of calculating it, or if a formula was entered while the cell was formatted as text.
Work with spreadsheet formulas in WPS Office
WPS Office is a free, lightweight alternative for working with spreadsheets in a familiar interface. Open compatible Excel files in WPS Spreadsheets for an easier transition between office suites.

Frequently Asked Questions
Why does my formula update only after I press Enter?
Possible causes include calculation settings, circular references, stale workbook calculations, or a formula stored as text. Start with Formulas > Calculation Options and Formulas > Error Checking > Circular References.
How do I force Excel to recalculate every formula?
On Windows, press Ctrl+Alt+F9 to force a full recalculation of all open workbooks. Formulas > Calculate Now performs a standard recalculation.
How can I tell whether a formula is stored as text?
If the cell displays the formula rather than its result, check Home > Number Format and look for a leading apostrophe. Set the format to General, then edit the cell and press Enter.
Can links to another workbook cause outdated results?
Yes. If a formula depends on an unavailable or outdated source workbook, its result may not reflect current data. Check Data > Workbook Links or Data > Edit Links, depending on your Excel version.




