ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Formulas not updating until I save document (https://www.excelbanter.com/excel-discussion-misc-queries/118889-formulas-not-updating-until-i-save-document.html)

Brian

Formulas not updating until I save document
 
Hi, have a problem in that everytime I insert new figures into any of my
Excel Spreadsheet the formulas are not updating as they normally should. They
only update when I save the document. Does anyone know why this might be
happening and what I might do to resolve this problem?

Niek Otten

Formulas not updating until I save document
 
ToolsOptionsCalculation tab, check Automatic

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Brian" wrote in message ...
| Hi, have a problem in that everytime I insert new figures into any of my
| Excel Spreadsheet the formulas are not updating as they normally should. They
| only update when I save the document. Does anyone know why this might be
| happening and what I might do to resolve this problem?




All times are GMT +1. The time now is 06:58 PM.

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