Seems like automatic updating is off!
Open the Options by ALT+T and then "O".
On the Formulas Tab select the workbook calculation to Automatic.

Right now pressing "F9" would be updating your info.

"First Aid Computing" wrote:

I've been gone from work for 3 days. When I left, all was well. Now I find
that when new data is entered, the formulas do not update unless I hit Save.
Then the new results are displayed. It used to update as new data was
entered. What might have happened to cause this?