Fix Excel Formulas That Recalculate Only After F9
Question details
The user needs Excel formulas to recalculate automatically when their referenced values change.

- 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.
Check which workbooks are open in the same Excel session. Calculation mode applies across the session and can be influenced by another workbook.
Enable automatic calculation and recalculate all formulas
Use this method when formulas update only after a manual recalculation.
In Excel, select File > Options, then select Formulas.
Under Workbook Calculation, select Automatic and click OK.
Close other workbooks that may have set calculation to manual, then check File > Options > Formulas again to confirm Automatic is selected.
Press Ctrl+Alt+F9 to recalculate all formulas in all open workbooks, then change a referenced cell to check whether the affected formula updates.

Set automatic calculation with VBA
Use VBA when you need to set the current Excel session to automatic calculation through code.
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.

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.




