• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1028
  • Last Modified:

Problem with Excel saying files are corrupt

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
Rob Sanders
Asked:
Rob Sanders
  • 8
  • 2
1 Solution
 
ragnarok89Commented:
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
 
Rob SandersAuthor Commented:
The files having the issue come from different sources. What should I check for?
0
 
chcwCommented:
Can you post the corrupt Excel file?
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
Rob SandersAuthor Commented:
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
 
chcwCommented:
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
 
Rob SandersAuthor Commented:
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
 
Rob SandersAuthor Commented:
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
 
Rob SandersAuthor Commented:
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
 
Rob SandersAuthor Commented:
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
 
Rob SandersAuthor Commented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

  • 8
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now