The sheet calculations are probably set to manual. You can press F9 to do it manually or turn in automatic calculations.
To turn on automatic do the following:
Click the File tab, click Options, and then click the Formulas category.
Do one of the following:
- To recalculate all dependent formulas every time you make a
change to a value, formula, or name, in the Calculation options
section, under Workbook Calculation, click Automatic. This is the
default calculation setting.
- To recalculate all dependent formulas — except data tables — every
time you make a change to a value, formula, or name, in the
Calculation options section, under Workbook calculation, click
Automatic except for data tables.
- To turn off automatic recalculation and recalculate open
workbooks only when you explicitly do so (by pressing F9), in the
Calculation options section, under Workbook Calculation, click
Manual.
Note: When you click Manual, Excel automatically selects the Recalculate workbook before saving check box. If saving a workbook takes a long time, clearing the Recalculate workbook before saving check box may improve the save time.
Source
Is auto calculation turned on? If not, did you press F9 to update the calculations? – CharlieRB – 2014-08-28T11:13:19.977
You're welcome. If that is the suitable answer, please accept it by click the check mark on the left under the vote count. – CharlieRB – 2014-08-28T12:23:07.773