Solved

Excel 2007 error opening file, unreadable content

Posted on 2011-03-08
7
784 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
Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

 

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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

PaperPort has a feature called the "Send To Bar". It provides a convenient, drag-and-drop interface for using other installed software, such as Microsoft Office. However, this article shows that the latest Office 2016 apps (installed with an Office …
Some code to ensure data integrity when using macros within Excel. Also included code that helps secure your data within an Excel workbook.
This Micro Tutorial will demonstrate on a Mac how to change the sort order for chart legend values and decrpyt the intimidating chart menu.
This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.

867 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

Need Help in Real-Time?

Connect with top rated Experts

26 Experts available now in Live!

Get 1:1 Help Now