Comments on: Get rid of "The file is corrupt and cannot be opened" 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. You understand what I’m talking about if you ever encountered the "The file is corrupt and cannot be opened" error in Excel 2010. Still think it can’t open? Actually it can! Continue reading →

Comments page 4. Total comments: 390

  1. thank you!

  2. Worked PERFECTLY! Thanks a million!!!

  3. its working..thanks lot

  4. Appreciated, it really works.

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

  6. Thank you very much it helped me too

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

  8. 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 .

  9. Perfect, Thank you

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

  11. did not work ..

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

  13. 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 :)

  14. 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!!!

  15. didn't work on server 2012r2 office 2010

  16. Thank you very much. It worked perfectly.

  17. thanx it helped

  18. Thank you so much! That worked. That had been a major hassle for a long time.

  19. Thank you for solution it work perfectly!

  20. Had the same error and solution was similar but not the same.
    At step 4 I instead had to go to Trusted Locations and check "Allow trusted locations on my network." I then had to click "Add new location" and add the location of the supposedly corrupt file to the trusted locations list.

    Posting my solution here in case it helps anyone else.

  21. This is temporary solution for some excels, but even in many excel this trick is not working getting same error

  22. Mate you saved me hours of work, I thanks you soooooo much...

  23. Thanks so much!

  24. That works perfectly!

  25. Thank U so much
    That was so helpful

  26. I love you
    u r d bst

  27. Thanks a lot for the solution.

  28. It was awesome. Thanks

  29. excellent solution !!! thanks !!!

  30. It works. Thanks for the help
    /W

  31. thank you

  32. This method works but it can be dangerous for document. if you another way to solve this issue then please suggest me. I searched on internet but not got good idea.

    Thanks!

  33. Thank you!

  34. Thank U so much
    That was so helpful

  35. excle file corrupted

  36. Thank you.its good

  37. Thanks Team, really helped!!

  38. Fantastic! it works. U save my day. Thank you.

  39. Awesome. Thank you.

  40. Hello Team,

    I'm facing the same issue after upgrading my office 2010 to 2016. .xls file is not opening and getting same error "the file is corrupted and cannot be opened" even .xlsx file working fine.

    this suggested is very helpful to me. thanks team !

  41. I have a similar problem, but nothing to do with an upgrade.

    I have a macro enabled file open in XL2003, which originated as an xlxs file from XL2010. Conversion to an xls file was straightforward. I then in 2003 added the macros. It is now saved as an xlsm file, and when XL2003 saves it is reports that the file is being converted.

    Until the latest changes to the macros, the file could be saved, closed and re-opened. Now the macros do all they should do, the file can be saved, but if I close it it cannot be opened. XL reports that the file is corrupt.

    I can go, and have gone, back to an older version (v3) to make the changes again. Which I have saved now as v5. v4 cannot be opened by XL2003 on the original machine (the machine that saved the file). v4 and v5 cannot be opened on a different machine by XL2010.

    I am reluctant to close v5 on the original machine until I know that I can open the saved version elsewhere.

    Does anyone have any clue as to what may have happened? I am at a loss. I understand file corruption, and that a corruption may occur during the save operation, but do not expect it to hit what is really the same file (the v3 file saved as v4 and v5) in the same way on two different occasions, so I have discounted any file system or OS corruption.

    It may be something introduced by the converter that XL2003 is using when saving the file, but I do not understand why the converter would add to the file something that XL2003 does not understand. But even if it did, I would then still expect a later version of XL (XL2010) to be able to read and open the file.

    Thank you

    Coco

  42. clear, thanks

  43. Hey
    I am using Php to export the data from the database to excel sheet.
    I am saving the file using .xls extension
    $filename = "VMS_Report_" . date('Y-m-d') . ".xls";
    After exporting the data when I try to open the file it shows the file is corrupted and unsafe
    I am using Office365
    I tried all the possibilities that are available sources on internet

  44. Worked as a charm! Thanks!

  45. Thanks it worked.

  46. 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

  47. awesome. works. thanks

  48. its really working..lots of tnx

  49. So thnks

  50. thank you so much you save my life !!!!!!!!!!!!

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 :)