"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-01-07T09:16:15+00:00

    Unchecking options under Protected View worked for me. Thanking you.

    Was this answer helpful?

    0 comments
  2. Anonymous
    2013-01-09T13:37:11+00:00

    Thank you so much! I´d been trying to work on this problem for the entire past week to no avail! Since I read your solution its now working fine! Much appreciated!

    Was this answer helpful?

    0 comments
  3. Anonymous
    2013-01-10T00:52:13+00:00

    saved me a lot of time...:) cheers...:)

    Was this answer helpful?

    0 comments
  4. Anonymous
    2013-01-14T07:26:55+00:00

    Hi Ruchi Bisht, Thanks For Such very good Solutions Posted here, Its Working

    You resolve Prob.

    **Thanks & Regards,****Prashant Surve |**Proprietor | Siddhi Sai Arts

    Gr. & First Floor Progressive Villa E , Plot 73 Sector 19/20 CBD Belapur Navi Mumbai 400614.( Maharashtra) INDIA.

    Tel: +91 22 651 49 477 | 22 277 44 966 | 91 922 33 694 74. |**www.siddhisaiarts.com**|

    Email ID: | ******@gmail.com  | ********@siddhisaiarts.com********|******@siddhisaiarts.com**|

    We Offer :

    Designing |  Digital Printing  On Solvent Vinyl & Flex  **|**Eco Solvent Vinyl & Flex **|Inkjet Printing | Out Door Advertising | Glow Sign Board | CNC Cutting & Engraving Services | LED Illuminated Sign  | Channel Letters | Acrylic Letters | SS Etching Plaques | Neon Sign |**Vehicle Graphics | Stationery Printing Services | Sign Survey  |OOH Advertising |Directory Sign | Way Finding Sign | Pylons  | Safety Sign  | Decals |

    Maharashtra * Gujarat * Madhya Pradesh * Andhra Pradesh * Karnataka* Rajasthan

    Was this answer helpful?

    0 comments