"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: Newest
Most helpful Newest Oldest
  1. Anonymous
    2015-08-14T22:44:08+00:00

    Hi

    Just got of the phone to Microsoft Support.

    If you turn off Trust Settings then you switch them off for every file which may not be the best thing to do from a security point of view. Here's what they advised:

    1.Download the file or open the email.

    1. Right click the file.
    2. Click properties.
    3. Click the check box which says 'Unblock' in the bottom right of the dialogue box.
    4. Click ok.

    This changes the security for only that file rather than for everything. You only have to do it once for the file.

    A bit of a pain if you are constantly open new files, but for most of us its bearable and still secure.

    Hope it helps

    Dave

    Was this answer helpful?

    0 comments
  2. Anonymous
    2015-08-14T22:42:17+00:00

    Hi

    Just got of the phone to Microsoft Support.

    If you turn off Trust Settings then you switch them off for every file which may not be the best thing to do from a security point of view. Here's what they advised:

    1.Download the file or open the email.

    1. Right click the file.
    2. Click properties.
    3. Click the check box which says 'Unblock' in the bottom right of the dialogue box.
    4. Click ok.

    This changes the security for only that file rather than for everything. You only have to do it once for the file.

    A bit of a pain if you are constantly open new files, but for most of us its bearable and still secure.

    Hope it helps

    Dave

    Was this answer helpful?

    0 comments
  3. Anonymous
    2015-08-13T19:33:46+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.

    Ruchi--

    Works like a charm......unfortunately now I've lost my excuse and have to go back to work.  :-)

    Was this answer helpful?

    0 comments
  4. Anonymous
    2015-08-11T05:22:00+00:00

    This information was  so helpful

    Was this answer helpful?

    0 comments