ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Excel 2003 no longer automatically updates equations & charts (https://www.excelbanter.com/excel-discussion-misc-queries/161016-excel-2003-no-longer-automatically-updates-equations-charts.html)

bnault2006

Excel 2003 no longer automatically updates equations & charts
 
My copy of Excel 2003 has recently stopped automatically updating formulas
and charts in my worksheets, i.e. when I change values I have to basically
reset the equation or my source data to see the changes. I noticed this
after installing Office SP2, and opening old Lotus 1-2-3 files, although all
my Excel files are affected, not just the ones converted from Lotus. Any
thoughts?

Gary''s Student

Excel 2003 no longer automatically updates equations & charts
 
Tools Options Calculate Automatic
--
Gary''s Student - gsnu200748

bnault2006

Excel 2003 no longer automatically updates equations & charts
 


"Gary''s Student" wrote:

Tools Options Calculate Automatic
--
Gary''s Student - gsnu200748


awesome...thanks. I have no idea how that option got changed, but it seems
to be working now.

Don Guillett

Excel 2003 no longer automatically updates equations & charts
 
Excel takes calculation mode from the 1st workbook opened, unless changed.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"bnault2006" wrote in message
...


"Gary''s Student" wrote:

Tools Options Calculate Automatic
--
Gary''s Student - gsnu200748


awesome...thanks. I have no idea how that option got changed, but it
seems
to be working now.




All times are GMT +1. The time now is 08:04 AM.

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