And your sure your excel options --> Formulas --are set to automatic?