"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: Newest
Most helpful Newest Oldest
  1. Anonymous
    2012-04-25T05:49:30+00:00

    Thanks Sir.............

    Was this answer helpful?

    0 comments
  2. Anonymous
    2012-02-03T18:59:34+00:00

    I was still having issues so I did the following:

    File>Option>Trust Center>Trust Center Settings>File Block Settings>

    uncheck all of the versions of excel.

    Was this answer helpful?

    0 comments
  3. Anonymous
    2012-01-27T14:57:11+00:00

    I don't think it has anything to do with the trust center settings, all my computers are set to the default stuff and they all had the same problem until I took the NAS back and got a new 1 which has absolutely no problems at all. I can open, close, save as much as I like and have never encountered this problem on the new NAS which is a Western Digital, a completely different NAS then what I had before.

    I would have to assume it had something to do with how the NAS operates since I have a new 1 with no problems.

    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