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

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

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 and later. Still think you can't open it? Actually you can!
Excel message: The file is corrupt and cannot be opened in Excel 2010

How to open a corrupt xls. file in Excel 2010 - 365

Try the following steps to see how your precious .xls data appear in Excel 2010 and later:

  1. Open Excel.
  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!

Table of contents

387 comments

  1. spot on, thank you!

  2. It worked thanks

  3. Genius! Such an unhelpful (and wrong) message from Excel after downloading a .xlsx file from Google Docs. Fixed by simply unticking these boxes. Thank you.

  4. Thank you so much. Its works properly.

  5. Hailliluahhhhh!!! No thanks to microsoft troubleshoots

  6. WONDERFULL It works!! Thanks

  7. Thank you so much, it works!!!!!

  8. Thank you. is works!

  9. Thank you so much............

  10. THANK YOU

  11. Thank you! You helped me out alot!

  12. Thank you so much! it worked :)

  13. Thank you so much… Its working fine

  14. it help, thanks alot. abit late to find this resolution. at least no more problem.

  15. Thank you! This saved me from wasting time...

  16. Thanks a lot... It works!!!

  17. Thank you, Works great now!

  18. Thank you so very very much!!

  19. Thanks so much

  20. a big THANK YOU, i tried so many other suggestions, non worked, yours worked first time.

  21. Awesome, thanks so much, this was driving me crazy.

  22. thank you

  23. Vow!!!Brilliant ....was trying from a very long time...n i got much appreciations from my boss after fixing this problem, thx Mr.Alexander

  24. thnks alot..really worked...

  25. thanks alot..it helped

  26. Works great now! Thanks!!! Thought the issues was within Outlook, but it was Excel having the issues.

  27. Thank you. I have same "bug" in my PowerPoint. Now all "set up" is unsecured, and work fine! :)

  28. Thank you that worked.

  29. Thank You very much, I had been moving docs to a different PC to Open the Excel docs. You have helped me from botheration

  30. thank u thank u thank u so much
    its working

  31. Thank you so much...
    Its working super...

  32. Graet it's working

  33. it really works..

  34. Thanks...it worked

  35. thanks a lot its working fine.but when i enable the options again i am not able to open the attachments of mails what i have sent .Can you please give me permanent solution

  36. Thank you! it works for me, I was bored by this for several days, really a good tips.

  37. wow.... it worked!!.......thank u so much :) :)

  38. Thanku :)

  39. thank u so so so so much sir, u r gr8 :)

  40. MANTAPPPPPPPP

  41. Spot on!

  42. thk...

  43. Waaoooo!!!! its working now...

  44. THank u so much .. its helped me lot ..

    Sathish.K

  45. Awesome. Thank you!

  46. Thanks Dear ! its working fine.. :)

  47. Thanks a lot. The solution works

  48. Thank you so much! Microsoft was useless but your fix worked!

  49. verrrrrrrrrrrrrrrrrry thanks

  50. VERY THANK.

Post a comment



Thank you for your comment!
When posting a question, please be very clear and concise. This will help us provide a quick and relevant solution to
your query. We cannot guarantee that we will answer every question, but we'll do our best :)