Do you have calculate set to manual, rather than automatic.
Not sure what version of Excel you are using.
In Excel 2003 goto Menu-Tools-Options
Then select the Calculation Tab, and make sure that Automatic is selected in the Calculation section.
In Excel 2007 you get to this through the Office button, then Excel options at the bottom.
Then click the Formulas tab on the left.