"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-07-24T09:22:07+00:00

    I can't open excel file from excel 2010 in excel 2007.

    Was this answer helpful?

    0 comments
  2. Anonymous
    2013-07-24T14:15:13+00:00

    I tried all these methods. But to no avail.

    The error message I get is actually, 'Excel cannot open the file 'name.xlsx' because the file format or file extension is not valid....

    Moreover, The Account Clerk working in my office saved this document on the FLASH drive. Now, she needs to tender reports to the company's Admin.

    So, what could be other possible recovery solutions please?

    As the IT person, I have tried all possible means to recover the document and some other documents as well in the FLASH drive which have been corrupted.

    Please help me.

    Thank you.

    Was this answer helpful?

    0 comments
  3. Anonymous
    2013-08-08T18:10:32+00:00

    excellent trouble shooting!

    Was this answer helpful?

    0 comments
  4. Anonymous
    2013-08-28T01:45:46+00:00

    I was having problem with MS-Office corrupting the files on Save. I found that there was no Virus. But the iTunes had errors in Application log. I removed all Apple Products and then MS-Office seemed to be working fine. And then reinstalled iTunes.

    Just my 2 cents for some one having similar problem.

    Was this answer helpful?

    0 comments