Fix Excel Formulas That Stop Calculating Automatically
Question details
The user needs Excel formulas to recalculate automatically when worksheet values change.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- A workbook contains formulas or charts that should update when their source values change.
- Observed behavior
- Results update only after a cell is reselected or the workbook is manually recalculated.
Open the affected workbook in Excel and identify a formula whose result does not update. Check whether changing one of its input cells leaves the displayed result unchanged.
Set Excel Calculation Options to Automatic
Use this when the workbook is in manual calculation mode and formulas do not update after inputs change.
In Excel, select the Formulas tab and click Calculation Options.
Select Automatic from the Calculation Options menu.
Change an input cell used by the affected formula and check whether the result updates automatically.

Find and Resolve Circular References in Excel
Check for circular references if formulas still do not recalculate as expected after automatic calculation is enabled.
Work With Excel Formulas in WPS Spreadsheets
WPS Office is a free, lightweight alternative with a familiar spreadsheet interface. Open compatible Excel files in WPS Spreadsheets to continue working with formulas and ease your migration; it does not change Excel's calculation settings.

Frequently Asked Questions
Why do my Excel formulas update only when I recalculate?
Excel may be set to manual calculation. Go to Formulas > Calculation Options and select Automatic, then change an input cell to test the formula.
How do I find a circular reference in Excel?
Check the status bar for a Circular References warning, or go to Formulas > Error Checking > Circular References and select a listed cell.
Should I remove every circular reference?
No. Some workbooks use circular references intentionally with iterative calculation. Inspect the formula and confirm the workbook's intended design before changing it.
Why is my chart not updating when its source values change?
The chart's source formulas may not be recalculating. Select Formulas > Calculation Options > Automatic and check for circular references in the source cells.




