2007 Excel doing strange things?


  1. basils57
    Posts : 150
    Windows 7 Home Premium 64bit.
       New #1

    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 Computer
    Quote Quote

  3. Golden
    Posts : 19,383
    Windows 10 Pro x64 ; Xubuntu x64
       New #2

    Hi,

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

    Regards,
    Golden
      My Computer
    Quote Quote

 

  Related Discussions
The “problem” I’m concerned about is that I noticed existingExcel 2007 xlsx files are now saving with fewer Kb. I have a Lenovo W700ds and a W541. Both computers are running Windows 7 Pro 64bit. The W700 has Office 2007 and theW541 has Office 2013. Both versions ofExcel are 32 bit as far as I...
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...
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...
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...
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?
Our Sites
Site Links
About 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 16:39.
Find Us