Formulas don't update

  • Thread starter Thread starter First Aid Computing
  • Start date 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?
 
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.
 
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...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formulas don't update. 1
VLOOKUP refuses to automatically update 1
Windows 11 Windows 11 update 5
Access Property sheet data missing also syntax 0
Formula Audit mode active in one column only; cannot kill. 2
Please Help! Virus? Avast, Firefox, Windows update quit working 4
updating formulas 4
How do you turn off Calculate mode in excel? 3

Back
Top