Solved

Problem with Excel saying files are corrupt

Posted on 2011-03-08
13
988 Views
Last Modified: 2012-05-11
I have had a few different users let me know that they are unable to open some Excel files because Excel says they are corrupt. The common configuration of the users that I have seen having this problem is Windows 7 Pro/Enterprise 32 bit and Microsoft Office 2007 with all available updates. I have taken these same "corrupt" files and attempted to open them on a Windows 7 machine running Office 2010 and run into the exact same problem. However, Windows XP machines running Office 2007 do not appear to have the problem. The problem happens even if you save the emailed file directly on the computer first and then open or if you open the file directly in Microsoft Outlook. The exact sequence of messages after you open the file are the following:

"Excel found unreadable content in 'nameofexcelfile.xls'. Do you want to recover the contents of this workbook? If you trust the source of this workbook, click Yes."

after you click yes:

"Unable to read file."

after you click ok:

The workbook cannot be opened or repaired by Microsoft Excel because it is corrupt.

and all you can do is click ok.

Any help I could get in resolving this would be greatly appreciated. I will post additional relevant info as I come across it.
0
Comment
Question by:Rob Sanders
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 8
  • 2
13 Comments
 
LVL 8

Expert Comment

by:ragnarok89
ID: 35073649
I have seen this when users open an existing file, which is corrupt to begin wth, make changes, and save it as a new file.

If your users are using an existing source file, check it.
0
 
LVL 1

Author Comment

by:Rob Sanders
ID: 35073718
The files having the issue come from different sources. What should I check for?
0
 
LVL 8

Expert Comment

by:chcw
ID: 35076396
Can you post the corrupt Excel file?
0
Office 365 Training for IT Pros

Learn how to provision tenants, synchronize on-premise Active Directory, implement Single Sign-On, customize Office deployment, and protect your organization with eDiscovery and DLP policies.  Only from Platform Scholar.

 
LVL 1

Author Comment

by:Rob Sanders
ID: 35076967
Unfortunately it has confidential info in it. I will see if I can make a dummy corrupt file that I can post for you to look at.
0
 
LVL 8

Expert Comment

by:chcw
ID: 35089086
If not the original corrupt PST file, but a dummy one, then I cannot analyze and see if the original one can be recovered or not.
0
 
LVL 1

Author Comment

by:Rob Sanders
ID: 35089097
I'm not concerned about recovering any data as I am able to open the file properly on the Windows XP workstations, just not the Windows 7 ones.
0
 
LVL 1

Author Comment

by:Rob Sanders
ID: 35096775
An interesting facet of this that I have come across, is that if I open up the Excel file on one of the Windows XP machines where it works and just resave it and then open it again on one of the problem machines, it starts working without a problem.
0
 
LVL 1

Author Comment

by:Rob Sanders
ID: 35096876
I also found a couple of other EE questions that seemed to deal with this issue but neither one would fix my problem:

http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel/Q_26717337.html?sfQueryTermInfo=1+10+30+7+corrupt+excel+window

0
 
LVL 1

Author Comment

by:Rob Sanders
ID: 35096879
0
 
LVL 1

Author Comment

by:Rob Sanders
ID: 35096904
Here is another thread that deals with this issue as well. I will keep posting them as I find them:

http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel/Q_24911213.html?sfQueryTermInfo=1+10+30+7+corrupt+excel+window

0
 
LVL 1

Accepted Solution

by:
Rob Sanders earned 500 total points
ID: 35318405
As a workaround for this problem I loaded Openoffice on the computers having this problem. I would open the Excel file in Openoffice then save it again and the problem would go away when I would go back to Excel. I think it would be worthwhile for people looking through Experts Exchange to know of this workaround.
0

Featured Post

Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

Question has a verified solution.

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

While working, an annoying popup showing below will come and we cannot cancel or close it form the screen. The error message will come again and again.
In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
This Micro Tutorial will demonstrate in Google Sheets how to use the HYPERLINK function to create live links inside your spreadsheet.
This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.

734 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