Is there any quick way to recover a corrupt Excel file?

Kerry W July 4, 2013
Pinterest Stumbleupon Whatsapp

I have more than 50 xls files in my excel database that I won’t be able to access. whenever I tried to open those files an error message prompts up on screen showing “file is corrupt and cannot be opened”. Now I have been searching for a tool that can repair excel file quickly and in a safe mode. Can anybody help??

Ads by Google

  1. Paul P
    August 12, 2013 at 5:58 pm
  2. Oron J
    July 5, 2013 at 1:45 pm

    Since the problem is occurring with multiple files, try to open them (or some of them anyway)on another computer first to establish that the problem is really with the documents and not with Excel. If they open fine, try repairing office (via the Programs and Features control panel). If it's the documents, search on line for "Excel recovery". T|here are plenty of good recovery programs out there, but if all fifty files are damaged, there may be a problem with your hard disc so your chances of success are not so good.

  3. Paul P
    July 5, 2013 at 1:11 pm

    Note my program, here's the link again because I don't see the post yet, http://sourceforge.net/projects/corruptexcelrec/, has for one of its tools an "Open in Safe Mode". However the search for temporary files feature is not conducted in Safe Mode but the search instead is done through the Explorer functionality and I don't see why it would matter if Windows overall and thus Explorer were in Safe Mode for that although you could certainly boot into Windows Safe Mode to try.

    Others can comment but I think WIndows Safe Mode and Excel Safe Mode behave differently.

    Once you find a file, "S2 Services Excel Recovery" would allow you to quickly open it in Safe Mode. If your files are flagged as not having the right extension, first change them to "XLS" from "TMP" or whatever.

    Make sure however that the format is not really XLSX underneath. Recent versions of Excel insist that the right extension be given for the file or they won't open. You can try to change some of the xls files to xlsx to see if that is the case.

    Another way to check if the file is an als or and xlsx one is the download NotePad++. Then open in the files in that free program. The first two characters of a healthy XLS file are "ÐÏ" whereas the first two characters of an XLSX file (reflecting that XLSX files are in reality ordinarily zipped up collections of mostly XML files) are "PK".

  4. Paul P
    July 5, 2013 at 12:47 pm

    My program has a bunch of tools for recovering Excle files including one tool for looking for temporary versions of your files: http://sourceforge.net/projects/corruptexcelrec/

    There are also commercial tools that search for lost, temporary or deleted Excel files. Two prominent ones are RecoverMyFiles, http://www.getdata.com/, and Excel Regenerator: http://www.dposoft.net/excel.html. The latter has a no questions asked 30 day money back guarantee if it doesn't work.

    Finanlly, the owner of Recoveronix has kindly specified a free to use $39 value coupon for anybody using his online file repair service: https://online.officerecovery.com/. The coupon is "S2SERVICES". If any of those corrupt files you have now or recover have a non-zero file size, you can try uploading theme to the service and getting a free professional level recovery.

    To get the free recovery do a "Demo" recovery and then on the results page, scroll past the demo result to the field where you can put in a coupon code and use the one above without the quotes.

  5. Charlie Benz
    July 5, 2013 at 11:53 am

    Try Sys2tools excel recovery tool to repair corrupt excel file. You can recover multiple excel file with excel recovery tool with meta data remain intact.

  6. Monique G
    July 5, 2013 at 2:34 am

    you can use a software to transform your excel to other formats, maybe it will work

  7. Hovsep A
    July 4, 2013 at 8:32 pm

    What is Protected View?
    http://office.microsoft.com/en-us/excel-help/what-is-protected-view-HA010355931.aspx

    1. Open Excel
    2. Click on File then Options.
    3. Select Trust Center then Trust center settings.
    4. Select Protected view.
    5. Uncheck all the options under Protected View then click OK and restart Excel

  8. Bruce E
    July 4, 2013 at 8:07 pm

    What version of Excel are you using? What version are the files saved in? Have you attempted to use the Open and Repair option in Excel?

Ads by Google