Do you have calculation set to automatic?

Tools|Options|Calculation tab|check automatic.

Calculation mode is picked up by the first workbook you open in that session of
excel.

Sara wrote:

Hi All,,

I am using Excel 2003. I have several linked workbooks, and many worksheets
within those workbooks. About a week ago, the formulas in the worksheets
stopped automatically calculating. Once I press save, then the calculation
will update, but not before then. I do not recall doing anything to the
program that would make this change happen. Does anyone have any suggestions
why this is happening, or how I can fix it?

--

Dave Peterson