"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: Most helpful
  1. Anonymous
    2016-01-31T11:25: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.

    Hi, 

    Thanks for the advice but my file is an EXCEL online with One Drive.

    Any ideas please?

    Many thanks in advance.

    Was this answer helpful?

    0 comments No comments
  2. 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
  3. 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
  4. 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