| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel 2003 no longer automatically updates equations & charts
Tools Options Calculate Automatic
-- Gary''s Student - gsnu200748 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Spreadsheet SUM(C:C) or indeed any SUM no longer works Excel 2003 | Excel Worksheet Functions | |||
| My Excel Chart No Longer Auto Updates | Excel Discussion (Misc queries) | |||
| MS Office 2003 updates have screwed up Excel ! | Excel Discussion (Misc queries) | |||
| Excel Links Updates in 2003 | Excel Worksheet Functions | |||
| Excel 2003 Updates, and Errors | Setting up and Configuration of Excel | |||
Linear Mode
