"The file is corrupt and cannot be opened" error on office 2010 Excel while opening .xls files

Anonymous
2010-08-07T08:54:12+00:00

I recently upgraded my office to 2010 from 2007 after that i am unable to open any .xls files created by previous version

no issue with the files because i can open it in 2003 sp3 and 2007 sp2 versions

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments
Answer accepted by question author
Anonymous
2010-08-08T06:28:33+00:00

Try the following steps:

  1. Open Excel 2010.

2. Click on File > Options.

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

Was this answer helpful?

500+ people found this answer helpful.
0 comments

147 additional answers

Sort by: Oldest
Most helpful Newest Oldest
  1. Anonymous
    2011-10-28T05:14:37+00:00

    Still not working. Does that fact that I have Vista have anything to do with this?

    When I try to open a file, it causes Excel to close.

    Was this answer helpful?

    0 comments
  2. Anonymous
    2011-11-07T03:27:00+00:00

    I have had much the same problem except I can open the file but when I click on "Enable Editing", I then get the "File Corrupt" message.  Does anyone have any suggestions to allow editing once the file is open.

    Was this answer helpful?

    0 comments
  3. Anonymous
    2011-12-23T03:31:49+00:00

    I'm getting the same problem recently got a Iomega NAS and my dad copied a excel file over to it and opened it from the NAS then saved it only to find that when he went back to open it again after closing it excel keeps saying it's corrupt. I know it's not corrupt and I don't understand why Excel is saying it is. Open Office and Lotus Symphony both open the file fine. I've tried the suggestions and they did not work which is really frustrating because this is a very important excel spreadsheet which excel has now mucked up. The only good thing is that I have been able to open it in Lotus Symphony so can access it in some form it's just not formatted correctly but if Lotus symphony is going to open a excel spreadsheet then Excel can I suppose I could just teach my dad to use this instead of office.

    Was this answer helpful?

    0 comments
  4. Anonymous
    2012-01-26T23:13:12+00:00

    The uncheck all proteted items in trust center also works for Word...

    Was this answer helpful?

    0 comments