ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Formulas don't update. (https://www.excelbanter.com/excel-discussion-misc-queries/225854-formulas-dont-update.html)

First Aid Computing[_2_]

Formulas don't update.
 
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?

FARAZ QURESHI

Formulas don't update.
 
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?



All times are GMT +1. The time now is 01:19 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com