Last Updated on April 14, 2020 by Next Century
Problem
Are you having a problem that when updating an Excel spreadsheet, the formulas do not update automatically as values are entered or updates and the formula only updates after the formula is edited or the spreadsheet is closed and opened again.
Solution
This happens when Excel has been configured to NOT update formulas automatically. This setting applies to the program for the logged in user – so all spreadsheets will have the same issue.
The make Excel automatically calculate formulas again:
With Excel open, click on the File menu and then Options
In the left hand menu, select Formulas
Under Calculation options select Automatic
Click OK to save the changes
All the formulas will now automatically update using the current values.
