"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
    2014-02-13T17:05:20+00:00

    Your solution is for Excel 2010. I have this problem with Excel 2007. Is there a "Protected View" equivalent in Excel 2007? Or a different solution? Thanks in advance!

     Are you facing the same issue as mentioned in the beginning post of this thread, then you could try to first save the file and then open it normally ( double click on the file)

    If NO, please provide details for the same

    Does it happen with all the files or just  specific files ?

    Do those specific files have a trouble while you open them in your computer only ?

    Please let us know the mentioned details, based on which we could suggest

    Thanks,

    BLACK BARRON

    If this post helped, please mark it helpful | If this is  the answer that you are looking for, please mark this post as answer

    Was this answer helpful?

    0 comments
  2. Anonymous
    2014-02-04T21:40:45+00:00

    Your solution is for Excel 2010. I have this problem with Excel 2007. Is there a "Protected View" equivalent in Excel 2007? Or a different solution? Thanks in advance!

    Was this answer helpful?

    0 comments
  3. Anonymous
    2014-02-04T21:26:08+00:00

    This step did not help me after I rechecked the boxes it went back to claims of corrupt file and could not open.

    Was this answer helpful?

    0 comments
  4. Anonymous
    2014-01-31T13:06:25+00:00

    Thanks very much..It worked. I though I may not be able to open the file anymore but now I could open every file.

    Was this answer helpful?

    0 comments