"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
    2014-11-22T13:26:46+00:00

    Ok. Thank you. But you are reply so late i remove file ready. :(

    Was this answer helpful?

    0 comments
  2. Anonymous
    2014-11-21T22:15:14+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.

    Simple, to the point, and effective.  Thanks a mill.

    Was this answer helpful?

    0 comments
  3. Anonymous
    2014-11-01T09:05:45+00:00

    Dear Ruchi Bhat.!

    Thank you so much for your help. I was also having the same problem with excel 2010. Now it is resolved.

    With Regards,

    Atul

    Was this answer helpful?

    0 comments
  4. Anonymous
    2014-10-20T13:28:03+00:00

    changing the Protected View settings did not help in my case; however, changing the File Block Settings resolved my issue.  thanks so much for posting this fix.  definitely makes life easier to just click/open files instead of having to save them first.

    Was this answer helpful?

    0 comments