Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Is there an error log file that can provide details of the following Excel 2010 error?

The file is corrupt and cannot be opened.

Error in Excel 2010

In Excel 2003 some error messages would be displayed in the following format, with the name and the location of the file, with the error details as illustrated below:

Error in Excel 2003

Is similar information logged by Excel 2010?

share|improve this question
    
Just as a side node: Sometimes when I cannot open an Excel file with Excel anymore, opening it in OpenOffice/LibreOffice and saving it again does work wonders! –  Peter Albert Jan 20 '13 at 22:12

6 Answers 6

I would check in event viewer for any issues. If you are using windows 7 you can just type event viewer at the start bar and it will come up.

Post the outcome or issues as a comment.

After Google-ing I discovered the following steps at http://social.answers.microsoft.com/Forums/en-US/excslcreate/thread/93af59c1-946c-4f5f-83c1-bd6f58dbd94f. Note that this is for opening files. I currently believe that that is what the issue is.

Try the following steps:

  1. Open Excel 2010.
  2. Click on File > Options.
  3. Select Trust Center > Trust center settings.
  4. Select Protected view.
  5. Uncheck all the options under Protected View > OK.
  6. Restart Excel 2010 and try to open Excel documents.

I researched some more after after I found the previous quote. But all I could find is people trying to open XML pages that they screwed up. Are you doing anything like that, or is this just when you try to open Excel?

Good Luck-

share|improve this answer
    
hanks David, the only thing that shows up in the Event Viewer is under "Microsoft Office Alerts" Type: Information Description Event Type: Information Event Source: Microsoft Office 14 Alerts Event Category: None Event ID: 300 Date: 03/11/2010 Time: 13:59:51 User: N/A Computer: PC1 Description: Microsoft Excel The file is corrupt and cannot be opened. P1: 101294 –  kristof Nov 3 '10 at 14:04
    
wow... MS is so... helpful... Well I have done some Google-ing and have discovered the following page social.answers.microsoft.com/Forums/en-US/excslcreate/thread/…. I will add the steps that I see helpful to my answer. –  David Nov 3 '10 at 14:16
    
Thanks David, I came across that as well and it is actually solving the issue of opening the file. The problem is that I do not have the control over the excel settings as those are on our client machines. I wanted to find out what is the problem with the file itself so I could correct it at the source, I was hoping that some error log would give me some pointers –  kristof Nov 3 '10 at 15:50
    
I yes the file is in the "XML Spreadsheet 2003" format and it is generated programatically. It worked fine with Excel 2003 and 2007 but it is now causing issues with the 2010 version. –  kristof Nov 3 '10 at 15:54
    
So you need to figure out how to fix the XML file on the server? I'm just trying to make it very clear so that myself and others know how to help the issue. –  David Nov 3 '10 at 16:20

I also found that the issue is caused by the DataValidation tags. So far, I have been unsuccessful in changing the XML code so that any Excel 2010 client may open the file regardless of Protected View options.

However, I can offer another work-around that does not require disabling Protected View. After saving the XML file to your harddrive, right-click the file and select "Open with..."->"Internet Explorer". IE opens it like normal, and the user can edit/save. Once the file is "natively" saved once on the machine, Excel 2010 opens the file as expected (the first save essentially turns off Protected View for subsequent viewings).

If you found a way to edit the XML Spreadsheet 2003 code so that it opens without needing a work-around, then please mention it in the comments.

share|improve this answer
    
thanks Kobinator, unfortunately I did not find the solution that would eliminate the need for work around. From the solutions that I use apart form the changing protected view settings is adding the site to the trusted site list in the browser so the file will not be flagged as unsafe and will open ok –  kristof May 4 '11 at 13:25
    
Another option is to change the properties of the downloaded file. Once the file is downloaded, select properties and you should see in general tab: " The file came from another computer and might be blocked to protect this computer" and an "Unblock" button next to it. Once you choose unblock the file will open ok –  kristof May 4 '11 at 13:32
    
Cool, hopefully we can find a "server" solution. I'll post back if I make any improvements. –  Kobinator May 5 '11 at 17:32

We tend to use this method at work:

Open the workbook with 7 zip (right click workbook, 7 zip from context menu, open archive) and delete the custom XML folder. It’s the same as going to File > Info > Check for Issues and wiping out Custom XML there, but it’s the more invasive path to get there.

share|improve this answer

If you have Tuneup Utilities installed, maybe the solution is uninstall it.

TuneUp's Program Deactivator causes this kind of messages:

ProgramDeactivator.exe: 'not enough quota is available to process this command'

And Microsoft Excel will fire the dialog: 'The file is corrupt and cannot be opened'.

Maybe it is time for TuneUp Utilities team work along with Microsoft Office developers and find a solution to avoid this kind of incompatibility.

share|improve this answer

Run Repair The first thing to try is to open it with the Repair option in Excel. You can do this by

clicking on File and then Open. In the Open dialog box, single click on the Excel file and

then click on the small arrow next to the Open button.

Go ahead and click on Open and Repair and you’ll get a message asking if you want to repair,

which will recover as much data as possible or if you simply want to extract data, which will

copy out the formulas and values.

You can try to repair first and see if it can recover the whole file, if not, you can then

try to extract the data.

share|improve this answer
  • try opening the file in other apps that can open spreadsheets.... Open Office, Star Office or whatever the hell they call it, Google Docs even
  • do you have a unix OS available? Try porting the file there and getting someone to open it for you, you might recover more than what you bargained for, or partially recover
  • following the above, I'm not knowledgable on tablets but perhaps try to open it with an office app for tablets... you'll never know. So many different machines these days
  • back to windows have you tried to import the file instead of directly opening it? (in excel)
  • and.... try other microsoft excels if available to you (365?)

That's all I can think of! hope it helps (i too am not confident, i hate file/disk corruption)

share|improve this answer

protected by Community 12 hours ago

Thank you for your interest in this question. Because it has attracted low-quality answers, posting an answer now requires 10 reputation on this site.

Would you like to answer one of these unanswered questions instead?

Not the answer you're looking for? Browse other questions tagged or ask your own question.