Make sure your calculation is set to Automatic.

On the Formulas Tab, Calculation Options