Check that your formulae are set to calculate automatically (Formulas ribbon - calculation options).