Perhaps the file is set for Manual recalculation - click on Formulas | Calculation Options and ensure that Automatic is checked.

Thanks for the rep - if that takes care of your original question, please select Thread Tools from the menu above your first post and mark this thread as SOLVED.

Pete