Calculation Issues

Fix Excel Formulas That Recalculate Only After F9

Khadija KhanKhadija Khan Nov 18, 2026 869 views

Question details

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

Fix Excel Formulas That Recalculate Only After F9
Product
Microsoft Excel
Device & OS
not provided
Scenario
Some formulas in an Excel workbook update automatically, while others need a manual recalculation.
Observed behavior
Affected formulas show updated results only after the user presses F9.
Before you start

Check which workbooks are open in the same Excel session. Calculation mode applies across the session and can be influenced by another workbook.

Solution 1Recommended

Enable automatic calculation and recalculate all formulas

Use this method when formulas update only after a manual recalculation.

1
Open calculation settings

In Excel, select File > Options, then select Formulas.

2
Enable automatic calculation

Under Workbook Calculation, select Automatic and click OK.

3
Check other open workbooks

Close other workbooks that may have set calculation to manual, then check File > Options > Formulas again to confirm Automatic is selected.

4
Force a full recalculation

Press Ctrl+Alt+F9 to recalculate all formulas in all open workbooks, then change a referenced cell to check whether the affected formula updates.

Enable automatic calculation and recalculate all formulas
Calculation mode affects the session: Changing the calculation mode can affect all workbooks open in the same Excel session.
Free Microsoft Office alternative

Work with spreadsheet formulas in WPS Office

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 make the move between office suites easier.

Work with spreadsheet formulas in WPS SpreadsheetsCompatible with Microsoft Excel formats, including XLS and XLSXFamiliar interface for working with existing spreadsheetsFree and lightweight office suite
microsoft office alternative - wps office

Frequently Asked Questions

Where do I turn on automatic calculation in Excel?

Select File > Options > Formulas. Under Workbook Calculation, choose Automatic and click OK.

Why can another workbook change how my formulas recalculate?

Excel calculation mode applies to the current application session and can be influenced by the workbooks opened in that session. Check other open workbooks and confirm the setting under File > Options > Formulas.

What is the difference between F9 and Ctrl+Alt+F9?

F9 recalculates formulas that Excel determines need updating. Ctrl+Alt+F9 forces a full recalculation of formulas in all open workbooks.

Can VBA turn on automatic calculation for just one workbook?

The command Application.Calculation = xlAutomatic changes the calculation mode for the current Excel session, not just one workbook. It may affect all open workbooks.