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? |
Excel 2003 no longer automatically updates equations & charts
Tools Options Calculate Automatic
-- Gary''s Student - gsnu200748 |
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. |
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