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
thenoo

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
Golden
Microsoft MVP

Windows 7 Ult. x64
 
 

Hi,

Can you attach an example spreadsheet of this issue here?

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

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
Irene

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
Thread Forum
Splitting Files Excel 2003
Last week I downloaded a Custom POI .csv file for my Garmin Nuvi. It is a combined file that contains all Walmart, Samsclubs in the US. The file also included two .bmp icons, one for Walmart and one for the Samsclub. I renamed the Walmart .bmp icon to the exact file name of the Walmart.csv file so...
Microsoft Office
Excel 2003 sum formula problem
I have been entering currency data in Column B in Euros to an EXCEL 2003 s/s and the formula used has added these totals entered in that Column correctly until I reached a total sum of 74364.70 Euros ,this being the sum of entries in Rows B6 to B82 . This was reached with the formula showing as...
Microsoft Office
Formatting Excel 2010, Excel 2003
Hello, I want to create a table as in the drawing below, where the first cell is table-wide (as it contains the heading common (pertaining?) to all columns and rows under it) but, and this is where I cannot get it together, where those cells are divided into several columns. It's a cinch when...
Microsoft Office
Excel 2003 quits
When I change the formatting on a spreadsheet, ie. portrait to landscape, regular to bold font, etc, and try to save the file, I get an dialog box that says that Excel 2003 has quit, Windows 7 is trying to find out why, and I lose the editing done in that session. It happened 8+ times working on...
Microsoft Office
Can't open 2003 Excel Files in Excel 2007?
I'm not sure if it because the files are 2003 or not? When I try to open them an error message appears stating, "...the file you are trying to open is in a different format than specified by the file extension. Verify file is not corrupted and is from a trusted source..." These are my files. The...
Microsoft Office
Excel 2003 - Multiple Excel Open
Hi All, I don't know if I'm posting in the right area but I really need help. Before (In XP and Vista), when I have one excel file open and I go to desktop to open a different excel, it would open in the same excel program (2 files in 1 program) With Windows 7, when I open a different file, it...
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 11:20.

Twitter Facebook Google+



Windows 7 Forums

Seven Forums Android App Seven Forums IOS App