Solved

Excel 2007 error opening file, unreadable content

Posted on 2011-03-08
7
785 Views
Last Modified: 2012-05-11
I have 50 people all on the same laptop build.  Win7, Office2007.  They export a spreadsheet from a website and one user cannot open it.  The error is Excel found unreadable content and asks to restore, but this will not work because itn't a spreadsheet generated from the local machine.

Other users can open the file fine.  In fact, you can send the file from the machine that cannot open it to another machine and it works fine.  You cannot open the file in Excel 2010 either.  Instead, you have to change some of the rows to be formatted differently.  

My question is what setting in excel do you think is making this 2007 version behave like the 2010 because I need to remove it.

I've uninstalled and reinstalled Office.
0
Comment
Question by:LrdKanien
  • 3
  • 3
7 Comments
 
LVL 24

Expert Comment

by:jimyX
ID: 35078209
You can go through this article:
http://support.microsoft.com/kb/929766

Also make sure you do not have unsupported language in that file (Regional Settings).
0
 
LVL 30

Expert Comment

by:SiddharthRout
ID: 35078232
I have seen others in the past with the same issue, but see no solution. Does the file have any VBA content?

Sid
0
 
LVL 30

Expert Comment

by:SiddharthRout
ID: 35078235
jimyX: Sorry, didn't see your post when I refreshed.

Sid
0
Master Your Team's Linux and Cloud Stack

Come see why top tech companies like Mailchimp and Media Temple use Linux Academy to build their employee training programs.

 

Author Comment

by:LrdKanien
ID: 35078261
I'm seeing this all over the web and no answers.

http://www.sevenforums.com/microsoft-office/97132-excel-2010-unreadable-content.html

I can't open the file in Excel 2010, but others can open in Excel 2007 and one user can't open it in Excel 2007.
0
 
LVL 30

Expert Comment

by:SiddharthRout
ID: 35078288
LrdKanien: Does the file have any VBA?

Sid
0
 

Accepted Solution

by:
LrdKanien earned 0 total points
ID: 35092147
updating excel fully fixed the issue in 2007.  The files cannot be opened in 2010 still.


Consider this resolved, unless there is a 2010 solution.
0
 

Author Closing Comment

by:LrdKanien
ID: 35126478
Updated office and it works.
0

Featured Post

VMware Disaster Recovery and Data Protection

In this expert guide, you’ll learn about the components of a Modern Data Center. You will use cases for the value-added capabilities of Veeam®, including combining backup and replication for VMware disaster recovery and using replication for data center migration.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this article we discuss how to recover the missing Outlook 2011 for Mac data like Emails and Contacts manually.
This code takes an Excel list of URL’s and adds a header titled “URL List”. It then searches through all URL’s in column “A”, looking for duplicates. When a duplicate is found, it is moved to the top of the list. The duplicate URL’s are then highlig…
This Micro Tutorial will demonstrate in Microsoft Excel how to add style and sexy appeal to horizontal bar charts.
This Micro Tutorial demonstrates in Microsoft Excel how to consolidate your marketing data by creating an interactive charts using form controls. This creates cool drop-downs for viewers of your chart to choose from.

777 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question