Nov
30

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!

See also

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

  1. JD says:

    This did the trick
    Thank you

  2. cherif says:

    you are the best i have a client at work who have issue and i was able to help them thanks

  3. muthu says:

    Thnanx lot this solution

  4. edwards142 says:

    If you are getting error message "The file is corrupt and cannot be opened" in Excel 2010 while trying to open any of your saved excel document then you can fix this issue by using MS Excel Repair tool. It is especially designed to resolve the error that occurs while using the excel file.

  5. catherine n. rentar says:

    I saved my files in my flash drive, unfortunately my flash drive has been corrupted. I am trying to open my recent excel files, but it says could not be found, check the spelling of the file name and verify that the file location is correct. Is there any possible way where I can save and open my recent documents.

  6. catherine n. rentar says:

    I saved my files in my flash drive, unfortunately my flash drive has been corrupted. I am trying to open my recent excel files, but it says could not be found, check the spelling of the file name and verify that the file location is correct. Is there any possible way where I can save and open my recent documents. I tried to recover my files from my flash drive but 0 files detected

  7. Jeslene says:

    You are a genius!! Been searching the answers for years and bingo you are good!

  8. Andrea says:

    THANK YOU SO MUCH!!! It worked for me!!!!

  9. Sally says:

    Thanks so much! I was having trouble with an Excel file after upgrading to Windows 10 (file had been opening fine before the upgrade) and this fixed it.

  10. Benjamin says:

    Thanks a million!

  11. Gus says:

    Thanks bro!! I was almost breaking this PC!

  12. Karla says:

    thank you!!

  13. Stephen Tamlin says:

    this worked! Thanks very much!

  14. Bikash says:

    No protected view in my excel option.
    How to solve?

  15. stephanie says:

    Worked for Excel 2016.
    Thanks

  16. suryapal says:

    Thanks man, I appreciate it.

  17. mustapha says:

    Its work for me when I uncheck all open in file block settings under trust center.

  18. Heydar says:

    Thanks a lot...
    my excel is working now

  19. Devarajan K says:

    Thanks a man really it worked

  20. Santosh-Lex International says:

    My Excel File Is Currept I Requst for you Repair file

  21. DC says:

    Hi,
    I have a file that has the same message when opened in excel 2007 "The file is corrupt and can not be opened". But I still open it in excel 2010.

    Please help!

  22. George says:

    Thanks.Its working fine

  23. Porthos says:

    Worked like a charm...Thanks a ton...!!!!

  24. GAURAV says:

    Thanks man u r such a genius... was facing problem.long time finally it works ...thnk u so much

  25. Ashish Sinha says:

    "Thank u so much for this info.my issue is resolved."

  26. sathish says:

    Hi sir,my excel file delete after that i use one recovery software fianlly find that excel sheet.when i open that excel sheet the file format and extension of don't match excel. the file could be corrupted or unsafe.please hlp me how to fix

  27. tazbir says:

    excel sheet not open showing this error
    "excel file not open because file format or file extension is not valid verify that file has not been corrupted and file extension match the format of file"

  28. S.R.Arul says:

    Thanks a lot for your solution

  29. Rohit kumar says:

    Thanks a Lot, Now its working.

  30. KMarshall says:

    Yay! Thanks!

  31. Salitha says:

    Its working Thanks lot

  32. John says:

    It fixed but setting does not retain after system restart.

  33. pallav says:

    nice man

  34. JEN says:

    THANKS!! YOU SAVE ME!!!!

  35. Jerry says:

    THANKS!! YOU SAVE ME!!!!

  36. faizal says:

    "excel file not open because file format or file extension is not valid verify that file has not been corrupted and file extension match the format of file"

  37. Rachelle says:

    YAY!!!! Thank you so much!!

  38. TC says:

    Thanks...Much appreciated!

  39. Muthu says:

    Great it worked for me
    Thanks

  40. Ajit says:

    Hello,
    I have tried this settings and also tried the dcomcnfg settings but still the problem is not resolve.I have also repair the MS office 2010 but no use.Still the files are showing the same error.
    This file is working on normal PC but showing error in thin client which is connected to windows server2008r2

  41. Mahesh says:

    ok. thanks sir

  42. Mike says:

    Yesterday I had a password protected spreadsheet open for a couple hours. I saved and closed the file, then about 3 hours later I went to open it and it said the file was corrupted and couldn't be opened. Also the date of the file was from the previous day not yesterday. I have tried all the online solutions I can find as well as yours and they do not work. At work I use Excel-2010 and at home I use Excel-2016 This is a very important file to me, Can you help?

  43. Sahil Arora says:

    Thanks!

  44. Srinivasan says:

    excel canot open the file beccause the file format or file extension is not vaild. verify that the file has not been corrupted and that the file extension matches the format of the file -how to recover the file

    Only one file i see this msg other files are ok

  45. Suan says:

    Thanks a lot

  46. Srinivasan says:

    Hello,

    I had excel sheet (no backup) which i opened after 10 days, now it shows .xls: file format is not found. I tried using repair and open option and unfortunately not working.

    Kindly help

  47. Annonymous says:

    Woo Hooo...
    You sir, Deserves a Cookie!!!

  48. varun says:

    great..issue resolved

  49. Venu says:

    Superrrrrrrrrr.... nice

  50. jithendra jayasanka says:

    Thank you so much

  51. Pratyaksh says:

    thanks a ton buddy

  52. Blessings says:

    Perfetc :D

  53. Ng says:

    Working now...Thanks

  54. ehldanela says:

    still cant :(

  55. Aarti says:

    not working ,give option for 2007 version where there is option of macro settig

  56. Aarti says:

    not working please give alternate option for 2007 version as we have option of macro setting not protected view

  57. Aarti says:

    Someone pls reply if u know the route cause i lost my most imp excel and i dont have any copy of it.

  58. Aarti says:

    Thanks to Mr.Rajesh Peshiya who helped to recover all data from that file. Thank you so much i got back files which corrupted.

  59. Aarti says:

    Thanks in tons

  60. xiou tin says:

    thanks a lot it is working !

  61. Tharindu & Upul says:

    Thanks Machan it's working fine....
    From Sri Lanka.
    You save our time !!! Ella Kollak.

  62. Simon says:

    Thank you very much, Machan it's working fine....
    Best wishes from Sweden.
    You save our time !!! Simon.

  63. LEA says:

    Hi good afternoon, can someone help me to restore my excel file. It became 0 byte and cannot be opened, Thank you in advance.

  64. Jeffrey says:

    Still happening

  65. Jeff says:

    Odd. Two machines in our office, and only one had this problem. The Trust Center settings were identical for both in both Word 2010 and Excel 2010. But one of them would not open downloaded files at all, always saying they were corrupt. Your solution did work, but it doesn't make sense that it's a problem on one machine and not the other.

    Anyway. Thanks!

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!
Excel add-ins and Outlook tools - Ablebits.com
Ultimate Suite for Excel Professionals
 
 
60+ professional tools for Excel 2016-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
Awesome!!!
Sheila Blanchard