Windows 7 Forums
Welcome to Windows 7 Forums. Our forum is dedicated to helping you find support and solutions for any problems regarding your Windows 7 PC be it Dell, HP, Acer, Asus or a custom build. We also provide an extensive Windows 7 tutorial section that covers a wide range of tips and tricks.


Windows 7: Excel 2003 s/s AutoSum not responding


24 Jun 2011   #1

Windows 7 Home Premium x64
 
 
Excel 2003 s/s AutoSum not responding

I have been entering data into Excel 2003 s/s with column B containing currency amounts using the AutoSum formula to get running totals as each row is entered. This has been adding the totals OK until the present cell B67. Suddenly the AutoSum has stopped adding additional entries. If I click on the cell showing the AutoSum Formula it shows "=SUM(B8:B67)" i.e. without quotation marks. If I delete row 67 the total decreases OK by the deleted amount and the SUM Formula adjusts accordingly but nothing changes if I attempt to add an amount to Cell B67 , i.e. it remains at the deleted total. This has just happened today when I resumed adding data to this s/s. The only change I did yesterday was to add a fourth column which contained Dates of new data entered which I was not in possession of for the previous entered data. Can you explain this failure of the AutoSum Function here ?


My System SpecsSystem Spec
.

24 Jun 2011   #2

Microsoft Community Contributor Award Recipient

Windows 7 Ult. x64 Windows 8.1 x64
 
 

Hi,

Can you attach an example spreadsheet of this issue here?

Regards,
Golden
My System SpecsSystem Spec
25 Jun 2011   #3

Windows 7 Home Premium x64
 
 
Solved!

Thanks to all who replied here. I found that the SUM FORMULA had not been installed far enough down in order to include all the ROWS required. Apologies for bothering everybody with such an obvious mistake !
My System SpecsSystem Spec
.


25 Jun 2011   #4

Windows 7 Home Premium 64bit
 
 

Quote   Quote: Originally Posted by thenoo View Post
Thanks to all who replied here. I found that the SUM FORMULA had not been installed far enough down in order to include all the ROWS required. Apologies for bothering everybody with such an obvious mistake !
Well done, thenoo.
My System SpecsSystem Spec
Reply

 Excel 2003 s/s AutoSum not responding




Thread Tools



Similar help and support threads for2: Excel 2003 s/s AutoSum not responding
Thread Forum
Excel 2003 Suddenly Stopped Responding to Formula Changes Microsoft Office
Solved Excel 2003 sum formula problem Microsoft Office
Formatting Excel 2010, Excel 2003 Microsoft Office
Excel 2003 quits Microsoft Office
Excel 2003 Macro Help? Microsoft Office
Can't open 2003 Excel Files in Excel 2007? Microsoft Office
Excel 2003 - Multiple Excel Open Microsoft Office

Our Sites

Site Links

About Us

Find Us

Windows 7 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 7" and related materials are trademarks of Microsoft Corp.

Designer Media Ltd

All times are GMT -5. The time now is 12:15 PM.
Twitter Facebook Google+



Windows 7 Forums

Seven Forums Android App Seven Forums IOS App
  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33