Get rid of "The file is corrupt and cannot be opened" in Excel 2010

Quick tip: learn how to access a corrupt xls. file in Excel 2010

Usually when upgrading you expect nothing but improvements. So it can be really disappointing when after moving to Excel 2010 you have no chance to access your .xls file created in the application version 2003 and earlier. You understand what I'm talking about if you ever encountered "The file is corrupt and cannot be opened" error in Excel 2010. Still think you can't open it? Actually you can!

The file is corrupt and cannot be opened in Excel 2010

Try the following to see how your precious .xls data appear in MS Excel

  1. Open the application.
  2. Click on File -> Options.
  3. Select Trust Center and press the Trust center settings button.Excel: Trust center settings
  4. Pick Protected view.
    Trust center - Protected view
  5. Uncheck all the options under Protected View and confirm by pressing OK.
  6. Restart Excel and try to open the broken Excel documents.
Note. For safety reasons, you should save your document with new Office format like .xlsx. You can do it this way: File > Options -> Trust Center -> Trust Center settings -> Protected View.
Check all the options again under Protected View, click OK and restart Excel.

This will set the security options back. Sure, you don't want to open any file unsafely.

That's it. Hope it will work for you and your documents :).

Thanks and see you!

You may also be interested in:

333 Responses to "Get rid of "The file is corrupt and cannot be opened" in Excel 2010"

  1. Raj says:

    thanx it helped

  2. Edwin Lawrence Lowery says:

    Thank you very much. It worked perfectly.

  3. robert says:

    didn't work on server 2012r2 office 2010

  4. Michele Singer says:

    THANK YOU, so much! I had a spreadsheet logging 20 years' worth of irreplaceable data that suddenly gave me this error message - following your steps fixed it perfectly! THANK YOU!!!

  5. K says:

    Thank you! Was having this issue for a while. Resorted to opening files in Google Sheets then copying into Excel. Wasn't great. Your solution works a treat :)

  6. Camilius Amevorku says:

    This worked for me perfectly and save tons of my time and frustration. Thanks!

  7. julien says:

    did not work ..

  8. Erin Jacob says:

    Thank you! This has been driving me nuts for the past week :)

  9. Jhon says:

    Perfect, Thank you

  10. RONEN says:

    Thanks so much worked just great this got me nuts for almost a year, also it always happen to me if the file was coming from Italy then it wont open now we all good to go thanks so much again .

  11. MAATE JOTHAM says:

    Thanks for that insight it has worked well for me, thanks

  12. Tam says:

    Thank you very much it helped me too

  13. VG says:

    Thank you so much for this tip. Saved me from agony.

  14. Victor says:

    Appreciated, it really works.

  15. subhasa MP says:

    its working..thanks lot

  16. Denise says:

    Worked PERFECTLY! Thanks a million!!!

  17. reri13 says:

    thank you!

  18. Eve says:

    Thank you so much!

  19. Preetha says:

    Thanks... This helped me a lot

  20. Sajeer says:

    thank you so much! it is working now.

  21. Abhinav Kumar says:

    Thanks alot! I use excel alot and have a lot of docs which are needed to be downloaded every day. I was quite worried about this when it showed up but now thankfully the problem is resolved.
    Cheers Buddy!

Post a comment

Unfortunately, due to the volume of comments received we cannot guarantee that we will be able to give you a timely response. When posting a question, please be very clear and concise. We thank you for understanding!
60+ professional tools for Excel
60+ professional tools for Excel
2019–2007 to do your daily work
Incredible product, even better tech support…AbleBits totally delivers!
Deborah Bryant
Anyone who works with Excel is sure to find their work made easier
Jackie Lee
The best spent money on software I've ever spent!
Patrick Raugh
Ablebits is a fantastic product - easy to use and so efficient.
Debra Celmer
Excel is at its best now
Annie C.
I don't know how to thank you enough for your Excel add-ins
Jennifer Morningstar
Anybody who experiences it, is bound to love it!
Kumar Nepa
AbleBits suite has really helped me when I was in a crunch!
Nelda Fink
I have enjoyed every bit of it and time am using it
Christian Onyekachi Nwosu
It's the best $100 we've ever spent!
Mike Cavanagh
I love the program, and I can't imagine using Excel without it!
Robert Madsen
One word… WOW!
Dave Brown
Love the products!
David Johnston
It is like having an expert at my shoulder helping me…
Linda Shakespeare
Your software really helps make my job easier
Jeannie C.
Thanks for a terrific product that is worth every single cent!
Dianne Young
I love your product
Brad Gibson
Sheila Blanchard