Formulas don't update

  • Thread starter First Aid Computing
  • Start date
F

First Aid Computing

Been gone from work for 3 days. When I left, everything was fine. Now I
find that when I enter new data into my sheet that nothing will actually
update (no computations) unless I Save it first. Then the new results with
the new data is displayed. It used to update as I entered data in. What
might have happened since the last time it worked?
 
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.

Best of luck.
 
F

First Aid Computing

It worked! Thank you!

FARAZ QURESHI said:
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.

Best of luck.
Click to expand...
 
Top