locked
Repair Excel Files after upgrade RRS feed

  • Question

  • Hello Experts: My problem is as follow: We're reinstall an Laptop With Windows 7, but the user does not back up a folder, This folder contained several important Excel files, we run "Easy recovery" this tool recover the most important files but the files are corrupt and are no possible open in Microsoft Excel. Someone know some way o app to repair this files, are very important because those have information that don't have stored in other database, mail or files.

    Sunday, June 12, 2016 4:57 PM

Answers

  • You can try Excel Recovery Toolbox  http://www.oemailrecovery.com/excel_recovery.html   to repair your corrupt Excel files.

    However, for your case, I think the problem may come with "Easy Recovery", although it recovers several files with .xls extension, it may just put some garbage data inside these files so actually these files do not contain any valid excel data. In that case, you cannot use any file recovery tools to recover the so-called .xls files. Therefore, you can check the raw data of the files and see if they actually contain the excel data. If you are not sure. You can upload it so that I can analyze the files.

    • Marked as answer by JohnsGreens Friday, June 24, 2016 2:23 PM
    Tuesday, June 21, 2016 3:49 PM

All replies

  • Hi JohnsGreens,

    Based on your description, after recovering an important Excel file, it was damaged and you cannot open it.

    First I suggest you confirm if the file format for this file is correct, if it's incorrect please change the file format to .xlsx.

    Then you can try to open a new Excel and go to Open- Open and Repair:

    Open and repair command

    You can refer to this support article about how to repair a corrupted workbook:

    https://support.office.com/en-us/article/Repair-a-corrupted-workbook-153a45f4-6cab-44b1-93ca-801ddcd4ea53?ui=en-US&rs=en-US&ad=US

    Hope it's helpful.


    Regards,

    Emi Zhang
    TechNet Community Support


    Please mark the reply as an answer if you find it is helpful.

    If you have feedback for TechNet Support, contact tnmff@microsoft.com.

    Monday, June 13, 2016 9:10 AM
  • Hi,

    The Excel xls/xlsx file format is very complex. It starts with several parts containing the actual data, followed by a file trailer containing the meta information of the file. You can find more detailed information about the Excel xls/xlsx file format by searching on Google with the keyword “Excel xls/xlsx file format”. If the file trailer containing the meta information is corrupt, or any other parts are damaged or corrupted, then you will not be able to open the file correctly with MS Excel. In such a case, the first step is to try to use the built-in repair or recovery function in the MS Excel, to see if it can repair or recover the corrupt file. If not, then you need to resort to a third-party excel repair software to scan the corrupted file and recover excel data for you. It is also possible to find a data recovery expert or company to do the task, but in most of the cases, they will also use a third-party tool to do the recovery for you.

    The main difference between using the software by yourself and by a third-party service company is:
    (1) The company is familiar with the data recovery industry so he knows which software is the best one. While you need to search and compare the software online by yourself, which is time-consuming.
    (2) The company purchases the software for multiple usages, while you purchase the software for one-time usage only. So normally the service fee may be cheaper than the license fee for the software.
    (3) DIY will keep your data confidential while do the recovery via a company may cause data breach.

    Below are several DIY methods to recover a corrupted or damaged Excel file:

    1. First of all, you can try to repair the file manually in Excel, as follows:

    (1) On the File menu, click Open.
    (2) In the Open dialog box, select the file you want to open, and click the arrow next to the Open button.
    (3) Click Open and Repair, and then choose which method you want to use to recover your workbook.

    You may find more information about this at:

    http://office.microsoft.com/en-us/excel-help/repairing-corrupted-files-in-excel-HA001034656.aspx (for Excel 2003)
    http://office.microsoft.com/en-us/excel-help/repairing-a-corrupted-workbook-HA010097017.aspx?CTT=1 (for Excel 2007)
    http://office.microsoft.com/en-us/excel-help/repairing-a-corrupted-workbook-HA010342840.aspx?CTT=1 (for Excel 2010)
    http://office.microsoft.com/en-us/excel-help/repair-a-corrupted-workbook-HA102749554.aspx?CTT=1 (for Excel 2013)

    2. If method 1 fails, there are still several methods to recover your Excel file manually with Excel, including writing a small VBA macro, as below

    http://office.microsoft.com/en-us/excel-help/repair-a-corrupted-workbook-HA102749554.aspx?CTT=1#_Toc337637262

    3. Third, there are also free tools from third-parties that can open and read Microsoft Excel files, for example,

    3.1 OpenOffice at http://www.openoffice.org. This is a very famous open source project that is designed to support Office file formats, including Excel files. The software can run under Windows.

    3.2 KingSoft Spreadsheets at http://www.kingsoftstore.com/office/free-excel. This is a free Windows tool that can open Excel files.

    Sometimes when Excel fails to open your file, these tools may be able to open it successfully. If that is the case, then after the Excel file is opened, you can just save it as a new file which will be error-free.

    4. For xlsx files, they are actually a group of files compressed in Zip file format. Therefore, sometimes, if the corruption is only caused by the Zip file, then you can use Zip repair tools such as WinRAR at http://www.rarlab.com to repair the file, as follows:

    4.1 Assuming the corrupt Excel file is a.xlsx, then you need to rename it to a.zip
    4.2 Start WinRAR, go to "Tools > Repair Archive" to repair a.zip and generated a fixed file a_fixed.zip.
    4.3 Rename a_fixed.zip back to a_fixed.xlsx
    4.4 Using Excel to open a_fixed.xlsx.


    There may still be some warnings when opening the fixed file in Excel, just let ignore it and Excel will try to open and repair the fixed file. If the file can be opened successfully, then you can just save the contents into another error-free file.

    5. If all above methods do not work, then you may try third-party tools such as DataNumen Excel Repair at

    https://www.datanumen.com/excel-repair/

    It provides a free demo version so that you can try to see if the data you want can be recovered or not.

    Good luck!

       

    • Edited by chcw Thursday, May 11, 2017 6:05 AM
    Tuesday, June 14, 2016 11:31 PM
  • You can try Excel Recovery Toolbox  http://www.oemailrecovery.com/excel_recovery.html   to repair your corrupt Excel files.

    However, for your case, I think the problem may come with "Easy Recovery", although it recovers several files with .xls extension, it may just put some garbage data inside these files so actually these files do not contain any valid excel data. In that case, you cannot use any file recovery tools to recover the so-called .xls files. Therefore, you can check the raw data of the files and see if they actually contain the excel data. If you are not sure. You can upload it so that I can analyze the files.

    • Marked as answer by JohnsGreens Friday, June 24, 2016 2:23 PM
    Tuesday, June 21, 2016 3:49 PM
  • Thank you guys for your feedback and help. Sorry, that long time did not respond. This is because the issue was solved and I forgot to tell.) Thank you!
    Friday, June 24, 2016 2:23 PM