"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
    2013-05-16T23:40:28+00:00

    I had this problem when opening xlsx files on a SharePoint 2013 site in Excel 2010 and 2013.  your Solution fixed both.  Thanks

    Was this answer helpful?

    0 comments
  2. Anonymous
    2013-06-07T06:25:47+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.

     

     

     

    Thanks....its working.

    Was this answer helpful?

    0 comments
  3. Anonymous
    2013-06-21T11:34:32+00:00

    I am experiencing this same problem and the solution of unchecking the options under protect view does not correct the situation.

    Help!  i cannot open any Excel files from Excel 2010 or Outlook 2010.

    thanks.

    Was this answer helpful?

    0 comments
  4. Anonymous
    2013-07-06T11:55:17+00:00

    The only solution that I have found so far is:

    1. Save file to computer
    2. Right click on file and go to properties
    3. On the General Tab look for a Security note at the bottom that says:

    Security:     The file came from another

    computer and might be blocked to

    help protect this computer.

    Press the "unblock" button if you are sure that this file is safe.

    The file should open now.

    Turning off the security options is not necessary and defeats the purpose of having them.

    Lisa

    Was this answer helpful?

    0 comments