"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: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2011-03-09T15:38:08+00:00

    Question -- I just installed the same version of Office 2010 on 4 different computers.  All are Windows XP and all had Office 2007, but only 1 of them needed this fix to open excel files. 

    Any idea why I needed this fix on one computer but not the rest?

    Was this answer helpful?

    0 comments
  2. Anonymous
    2011-01-27T17:56:01+00:00

    it worked for me. Now...I get this same excel email every day. If I go change it back the way it was, does that mean it won't work next time? I can't be doing this every day.

    Thanks,

    Was this answer helpful?

    0 comments
  3. Anonymous
    2011-01-02T13:32:32+00:00

    Great! It works!

    pc

    Was this answer helpful?

    0 comments
  4. Anonymous
    2010-11-01T15:51:11+00:00

    Thank you!!! I've had this problem as well and have been digging around in the forums for awhile now trying to find an answer.  I was on the verge of posting a new question when I found your response.

    THANKS!

    Brian

    Was this answer helpful?

    0 comments