| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel 2003's autosum does not update data in real time
The AutoSum is not working well. It does not auto update the data once amend
the value. I'm using Microsoft Excel 2003 Standard Edition SP2 under Microsoft Windows XP Professional SP2. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Excel 2003's autosum does not update data in real time
You probably have calculations set to manual under
toolsoptionscalculation, change that to automatic -- Regards, Peo Sjoblom Northwest Excel Solutions www.nwexcelsolutions.com (remove ^^ from email address) Portland, Oregon "KokWoei" wrote in message ... The AutoSum is not working well. It does not auto update the data once amend the value. I'm using Microsoft Excel 2003 Standard Edition SP2 under Microsoft Windows XP Professional SP2. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Excel 2003's autosum does not update data in real time
Is calculation set to manual???
Tools/Options/Calculation -set to automatic "KokWoei" wrote: The AutoSum is not working well. It does not auto update the data once amend the value. I'm using Microsoft Excel 2003 Standard Edition SP2 under Microsoft Windows XP Professional SP2. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Update External Data source from Excel sheet | Excel Discussion (Misc queries) | |||
| How do I update data in 3 related files in Excel? | Excel Discussion (Misc queries) | |||
| how do I import data (distance and time) from MapPoint to Excel? | Excel Discussion (Misc queries) | |||
| Update Excel Data List for Drop Down use | Excel Discussion (Misc queries) | |||
| How to continuously update time in Excel? | Excel Worksheet Functions | |||
Hybrid Mode
