Solved

Problem with Excel saying files are corrupt

Posted on 2011-03-08
13
960 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
  • 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
 
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
What Is Threat Intelligence?

Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

 
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

Backup Your Microsoft Windows Server®

Backup all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

Join & Write a Comment

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 …
This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
Graphs within dashboards are meant to be dynamic, representing data from a period of time that will change each time the dashboard is updated with new data. Rather than update each graph to point to a different set within a static set of data, t…
Learn how to make your own table of contents in Microsoft Word using paragraph styles and the automatic table of contents tool. We'll be using the paragraph styles in Word’s Home toolbar to help you create a table of contents. Type out your initial …

705 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

17 Experts available now in Live!

Get 1:1 Help Now