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 2010 - Unreadable Content

12 Jul 2010   #1
Roddy

Dual boot Win7 Home Premium and Vista Home Premium SP2
 
 
Excel 2010 - Unreadable Content

Hi

I have searched both here and via Google and cannot locate an answer to this.

I am now using Office (Excel in particular) 2010 at work, having upgraded from Office 2007 a month ago.

Every week for the past 18 months I have been receiving via email an Excel workbook in a .zip file, which I do some minor work on and fwd to my boss. I have always been able to Unzip it and open and edit it - until Excel 2010.

Now, after unzipping and opening I get the " Excel found unreadbale content in "XXXXXXX".xls. Do you want to recover the contents of this workbook? If you trust the source of this workbook, click Yes".

I click YES, and nothing opens.

I am also unable to open it after saving it to a location and going, from within Excel, File/Open - drilling down to located file then using Open and Repair command - again just a blank Excel page.

I keep reading about same issue in Excel 2007, where I never HAD the issue in 2007, about pivot tables (none on these workbooks) , external data sources (none on these workbooks) and ,finally, to remove the Current Time Member properties. If I can't open the file how do I do this????

Anyhelp would be GREATLY appreciated. These are vital files...

Rgds
Rod


My System SpecsSystem Spec
.
13 Jul 2010   #2
Johnathan Lyman

Windows 7 Ultimate 64-bit
 
 

Does the workbook have any complex formulas that link to external workbooks?

Since the file is coming in as .xls, is the creator's version of excel 2003?

Is it large? [> 5mb]?

How many sheets are in this workbook?

From my experience working with Excel a lot, there is a specific spot or cell in your workbook that didn't get terminated like normal when you exit a cell or press ENTER.

So answer those questions for me and see if you can't get the individual who created the workbook to re-create it mimicking all of the sheets and "Copy/Paste Values" the information over to the new sheet(s), save it after it looks right and send it to you.
My System SpecsSystem Spec
13 Jul 2010   #3
Roddy

Dual boot Win7 Home Premium and Vista Home Premium SP2
 
 

Hi Johnathon

tx for reply.

Its a 4 worksheet Workbook.

None of the sheets LINK to another.

Each is around 20 columns by 10 rows. Nothing too big.

I actually can't open it up, so I can't NOT hit ENTER anywhere....or I can't hit enter anywhere...

Its a total of about 28kb in size.

Rgds
Rod
My System SpecsSystem Spec
.

13 Jul 2010   #4
Johnathan Lyman

Windows 7 Ultimate 64-bit
 
 

Ok. It just sounds like there's some corrupted data or data that isn't terminated properly.

see if you can't get the individual who created the workbook to re-create it mimicking all of the sheets and "Copy/Paste Values" the information over to the new sheet(s), save it after it looks right and send it to you. Sometimes the only way to fix it is to get rid of it and start over, in this case.
My System SpecsSystem Spec
13 Jul 2010   #5
Roddy

Dual boot Win7 Home Premium and Vista Home Premium SP2
 
 

Hi Jonathon

sorry for tardy reply - time zone differences!!!

Another odd thing i just noticed - if I send the UNZIPPED file to my bosses email, open it up and unzip on his PC (still using Excel 2007) it opens perfectly....I can then edit and save my changes no probs.

So perhaps it's not per your thoughts - it seems Excel 2010 related?


Rgds
Rod
My System SpecsSystem Spec
14 Jul 2010   #6
Johnathan Lyman

Windows 7 Ultimate 64-bit
 
 

Quote   Quote: Originally Posted by Roddy View Post
Hi Jonathon

sorry for tardy reply - time zone differences!!!

Another odd thing i just noticed - if I send the UNZIPPED file to my bosses email, open it up and unzip on his PC (still using Excel 2007) it opens perfectly....I can then edit and save my changes no probs.

So perhaps it's not per your thoughts - it seems Excel 2010 related?


Rgds
Rod
If, when taking the zipping out of the process it works just fine all the way through, you may just have to send them without containing them in .zip files. Some email scanners try to decompress and scan zip files and if they are safe compress them back [usually only bigger companies and governments do that; I know when I work with the US Gov't, their scanner won't let password-protected PDFs through, even though you don't need a password to open or print said PDF [just to edit]]

What program(s) are being used to zip/un-zip?
My System SpecsSystem Spec
15 Jul 2010   #7
Roddy

Dual boot Win7 Home Premium and Vista Home Premium SP2
 
 

Using both WIN-RAR and WINZIP.

tried your method as above and now I get a prompt to Open & Repair, but no matter which I try (extract data or repair) I simply get a blank excel spreadsheet.

got me licked. Any Excel 2007 in office (another 8 PCs) opens this file properly, my Excel 2010, nada, which is kind of a bummer as we are having ALL PCs upgrading to Office 2010 over next 2-3 weeks...or we WANTED to!

Tks for efforts to date and Rgds
Rod
My System SpecsSystem Spec
Reply

 Excel 2010 - Unreadable Content




Thread Tools




Similar help and support threads
Thread Forum
Bug in Excel 2010?
For my workbook, I have defined the default font to be 11 pt Calibri. However, when I select a row (or column) and select Clear Formats, the cells are reformatted to 10 pt Arial. To me, this seems like a bug. Am I missing something?
Microsoft Office
How to go back from Excel 2010 64 bit to Excel 2010 32 bit
I have an important program that uses a DLL that only works with Excel 2010 32 bit. I'm running Excel 2010 64 bit now -- how do I install the 32 bit version? I have the CD which has both versions on it. But when I run Setup, it gives me options that I don't understand for this limited purpose. In...
Microsoft Office
Excel 2010
Hello, I'm having this weird problem with MS Office 2010. When I'm working on excel files tend to crash for no reason and too frequently when I try to open them. I have gotten these two messages: 1) Excel cannot complete this task with available resources. Choose less data or close other...
Microsoft Office
Saving Clipboard Content in Word 2010
Good day. I did a search for this, but could only find a post so old it was in the 2010 beta section, and I was warned about posting there. My problem is roughly the same as the OP: I work on complicated phonetic documents, and I would like to keep the contents of my Word clipboard when...
Microsoft Office
Export Outlook 2010 Exchange content from one computer to another?
Hello folks, I know with pop3 account it's quite easy: export everything to .PST and import with new computer. Is something like this possible with Exchange server accounts? Last time I tried (importing PST into Outlook exchange account) import went ok, all emails were there, calendar...
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


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:49.
Twitter Facebook Google+ Seven Forums iOS App Seven Forums Android App