Sounds like you have calculation set to manual.

Got the Formulas tab>Calculation Options>Automatic