"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 No 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 No comments

147 additional answers

Sort by: Newest
  1. Anonymous
    2015-12-21T03:45:17+00:00

    Right click on the file and go to properties. Make sure that read-only isn't checked and that there are no other attributes checked.

    Hi Lisa,

      Thanks for the reply and my apology for not responding sooner; I was having bigger problems with the Windows 10 upgrade and Kaspersky Total Security.  I did check the attributes and no attributes were checked.  However, I did click on Security within Properties and when I clicked on either "Everyone" or my UserID on this computer, I was able to open the files.  Apparently it remembered the ownership as belonging to me on the old computer and I had to change the ownership over to this computer.  I hope this helps anyone else with this problem.

    Was this answer helpful?

    0 comments No comments
  2. Anonymous
    2015-12-19T02:13:21+00:00

    Right click on the file and go to properties. Make sure that read-only isn't checked and that there are no other attributes checked.

    Was this answer helpful?

    0 comments No comments
  3. Anonymous
    2015-12-03T19:28:50+00:00

    I recently purchased MS Office 2016 and am running it on my desktop Windows 7 machine.  I have unchecked the protected files tabs and have tried both double clicking on an old .xls file and trying to open it from within Excel 2016.  I get two messages, the first that Excel is unable to open the file, and the second saying that the file is corrupt or read only, etc.  I understand that the new Excel uses the .xlsx extension, but when I try to change the extension on the old file I'm told I need to be the administrator, which I am.  That message just repeats without giving me a chance to enter my administrator password, or any way to prove I'm the administration.  Finally, I tried Microsoft's instruction to use the "change" option under uninstall for MS Office 2016, both local and internet and basically reinstalled Office.  Still unable to open those old Office 97/ 2003 Excel files.  Any help appreciated.

    Was this answer helpful?

    0 comments No comments
  4. Anonymous
    2015-12-03T16:05:39+00:00

    Unchecking protected view worked for me thanks.

    Was this answer helpful?

    0 comments No comments