ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Excel 2003's autosum does not update data in real time (https://www.excelbanter.com/excel-worksheet-functions/81330-excel-2003s-autosum-does-not-update-data-real-time.html)

KokWoei

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.

Peo Sjoblom

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.



JMB

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.



All times are GMT +1. The time now is 07:03 PM.

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