Memorise

Excel formulas not updating

Symptoms: The value returned by your Excel formula does not update automatically, i.e. the formula continues to show the old value even after you’ve changed the values of the dependent cells.

When Excel formulas are not updating automatically, most likely it’s because the Calculationsetting has been changed to Manual instead of Automatic. To fix this, just set the Calculation option to Automatic again.

On the Excel ribbon, go to the Formulas tab > Calculation group, click the Calculation Optionsbutton, and select Automatic:
For Excel formulas to update automatically, enable 'Automatic' under Calculation Options.

Alternatively, you can change this setting in Excel Options:

  • In Excel 2003, click Tools > Options > Calculation > Calculation > Automatic.
  • In Excel 2007, click Office button > Excel options > Formulas > Workbook Calculation Automatic.
  • In Excel 2010Excel 2013, and Excel 2016, go to File > Options > Formulas > Calculation optionssection, and select Automatic under Workbook Calculation.

Another way to turn on the Automatic Calculation setting.


Categorised as: Microsoft


Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.