Calculation Issues

Fix Excel Formulas That Stop Calculating Automatically

Phi Hung VoPhi Hung Vo Nov 18, 2026 869 views

Question details

The user needs Excel formulas to recalculate automatically when worksheet values change.

Fix Excel Formulas That Stop Calculating Automatically
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.
Before you start

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.

Solution 1Recommended

Set Excel Calculation Options to Automatic

Use this when the workbook is in manual calculation mode and formulas do not update after inputs change.

1
Open calculation settings

In Excel, select the Formulas tab and click Calculation Options.

2
Enable automatic calculation

Select Automatic from the Calculation Options menu.

3
Test the result

Change an input cell used by the affected formula and check whether the result updates automatically.

Set Excel Calculation Options to Automatic
Calculation mode can affect other workbooks: Excel's calculation mode can apply to other open workbooks as well, so check their results after changing the setting.
Free Microsoft Office alternative

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.

Work with formulas and calculation settings in WPS SpreadsheetsOpen and edit Microsoft Excel formats such as XLSX and XLSUse a familiar spreadsheet interface for an easier transitionAccess a free, lightweight office suite
microsoft office alternative - wps office

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.