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 6. Total comments: 390

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

  2. clear, thanks

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

  4. Worked as a charm! Thanks!

  5. Thanks it worked.

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

  7. awesome. works. thanks

  8. its really working..lots of tnx

  9. So thnks

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

  11. Fantastic, thanks a lot for sharing this

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

  13. Still happening

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

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

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

  17. thanks a lot it is working !

  18. Thanks in tons

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

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

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

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

  23. still cant :(

  24. Working now...Thanks

  25. Perfetc :D

  26. thanks a ton buddy

  27. Thank you so much

  28. Superrrrrrrrrr.... nice

  29. great..issue resolved

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

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

  32. Thanks a lot

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

  34. Thanks!

  35. 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?

  36. ok. thanks sir

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

  38. Great it worked for me
    Thanks

  39. Thanks...Much appreciated!

  40. YAY!!!! Thank you so much!!

  41. "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"

  42. THANKS!! YOU SAVE ME!!!!

  43. THANKS!! YOU SAVE ME!!!!

  44. nice man

  45. It fixed but setting does not retain after system restart.

  46. Its working Thanks lot

  47. Yay! Thanks!

  48. Thanks a Lot, Now its working.

  49. Thanks a lot for your solution

  50. 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"

    1. yeah .. on me too :(

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