Formulas don't update.

  • Thread starter First Aid Computing
  • Start date
F

First Aid Computing

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?
 
F

FARAZ QURESHI

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.
 
Top