Set Calculation to Manual before inserting the formulae. Then res-set to Automatic.

Formulas==>Calculation Options