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: 2007 Excel doing strange things?

29 Sep 2012   #1
basils57

Windows 7 Home Premium 64bit.
 
 
2007 Excel doing strange things?

I wonder if anyone can advise on the following please?

I have a long standing workbook in which one particular worksheet has suddenly started to operate strangely - when I insert figures into a column which is set up to be auto-summed, as soon as the second number is entered the sum becomes what appears to be a combination of the two numbers overlaid upon each other. Any consequent calculation involving that cell in say the row, also takes on the 'overlay' appearance.

I have tried test auto-sum etc on other worksheets in the same book and it would appear that the problem lies with this one sheet. It is confusing me, does anyone have any ideas please|?


My System SpecsSystem Spec
.

29 Sep 2012   #2
Golden

Microsoft Community Contributor Award Recipient

Windows 7 Ult. x64
 
 

Hi,

Can you attach a cut-down version of the spreadsheet, and I'll have a look for you?

Regards,
Golden
My System SpecsSystem Spec
Reply

 2007 Excel doing strange things?




Thread Tools





Similar help and support threads
Thread Forum
strange things going on with my HDD
I have an attached USB HDD (Seagate Expansion Desk 2TB) which I have assigned to M: It has data on it, but when I try to browse it in file explorer, it shows up completely empty. Sometimes if I reboot the machine, all the files show up. Sometimes it's blank again. If I go to PROPERTIES, it says...
Hardware & Devices
Excel 2007 (MS Office 2007 enterprise)
I recently formatted my HD and reinstalled MS Office Enterprise 2007, I last used MS Excel on the 08/06/2014 without a problem, today I go to use my Excel spreadsheet and for some weird reason it wants to roundup my cells. I have cleared the cells formatted the number but it still keeps on...
Microsoft Office
Strange things I don't know how to fix
Running Windows 7, Firefox, on a cable modem and have just started using 7. Here are a couple things that are driving me nuts. When I open my Firefox home page, my home page gets part way through loading and ten resets the the home page. Where this causes me problems is that I start to...
Network & Sharing
Cannot access the Ribbon functions in Excel 2007 or Word 2007
I have Office 2007 on Windows 7. When I am working on a sheet (or document) the ribbon can become inaccessible, nothing works when I click it (like a 'Not Responding' screen). If, I switch to another open sheet/doc and then switch back the ribbon is accessible again! I have...
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
A strange bug with Windows 7 and excel 2007
Check it out, If you password protect an excel file and have the preview option in the windows explorer switched on. Then if you try to open the file it will ask for the password, open the file in the preview pane but not in the excel window itself. Any solutions?
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 10:40.

Twitter Facebook Google+



Windows 7 Forums

Seven Forums Android App Seven Forums IOS App