You might have your Calculations set to Manual....

Go to Formulas tab and in the Calculation section, click Calculation Options and choose Automatic.

Does that fix it?