1. Welcome to Chandoo.org Forums. Short message for you

    Hi Guest,

    Thanks for joining Chandoo.org forums. We are here to make you awesome in Excel. Before you post your first question, please read this short introduction guide. When posting or responding to questions please remember our values at Chandoo.org are: Humility, Passion, Fun, Awesomeness, Simplicity, Sharing Remember that we have people here for whom English is not there first language and we need to allow for this in our dealings.

    Yours,
    Chandoo
  2. Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  3. When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

How to repair a corrupted excel file

Discussion in 'Excel Dashboards' started by quarterdeck, Feb 16, 2018.

  1. quarterdeck

    quarterdeck New Member

    Messages:
    3
    There is an Excel file that contains about 50 pages with formulas and references. It contains tables with formatting. One day when you run the file has not opened writes that the Office has executed the error and will be closed after restarting offers to restore the file. After that restores: I see all the formula data pages, but there are no tables and formatting completely.
  2. AliGW

    AliGW Active Member

    Messages:
    272
    You have two options:
    1. Go back to the last backup you took of the file (of course, you have backups ...).
    2. ... but if you don't have backups (why not?), you could try one of the many free online tools that claim to be able to rescue Excel files. Some have been known to work.
    Good luck!
  3. Joyce N Johnson

    Joyce N Johnson New Member

    Messages:
    9
    If the Excel file is corrupt, you should repair it. There are many vendors in the market which provide Excel Repair/Recovery tool. But before you can purchase any such paid software, you must download the free demo version to check what you can actually recover from the corrupt Excel file.
  4. Logit

    Logit Active Member

    Messages:
    259
    Here are a few suggestions I've used in the past :

    RESTORE CORRUPT FILE


    ONLY DO THIS ON A COPY OF YOUR FILE. IF IT WORKS, THEN YOU CAN PERFORM THE SAME ON THE ORIGINAL.

    Restoring a Corrupted File

    This is the reply from one of members re restoring a corrupted file

    The techs at Microsoft were able to restore the Excel file!

    I'm not sure what all they did (some of it was magic, evidently), but here's a tip they passed along.

    If you're having a problem with an Excel file, save it as HTML (which is one of the file types in Excel), then save it back to .xls

    They say that will often recover lost information, or restore a corrupt file.

    =================================================================================

    http://directory.s2services.com/excel.htm

    'provides a list of steps to recover a corrupt file

    =================================================================================

    https://support.office.com/en-us/ar...workbook-153A45F4-6CAB-44B1-93CA-801DDCD4EA53

    =================================================================================

    Another way of restoring broken/corrupted Excel files

    I've been quite lucky actually opening corrupted files in OpenOffice, saving them, and then re-opening them in Excel. Sometimes the formatting will be a little off, but the data is almost always recovered, as well as most of the formatting. Unfortunately, not all of the formula and charts are, but when it happened I was happy anything was salvaged at all :)
    ---------------------------------------------------------------------------------

    I also have had good results from these freebies :

    http://www.appspro.com/Utilities/CodeCleaner.htm

    http://www.download82.com/download/windows/excel-repair-kit/
  5. kritesh

    kritesh New Member

    Messages:
    1
    When Microsoft Excel detects a corrupted workbook upon opening, it automatically starts File Recovery mode and attempts to repair the workbook. If File Recovery mode doesn’t start, try using this manual process to recover your workbook:

    1. Click File > Open.

    2. Click the location and folder that contains the corrupted workbook.

    3. In the Open dialog box, select the corrupted workbook.

    4. Click the arrow next to the Open button, and then click Open and Repair.

    5. To recover as much of the workbook data as possible, pick Repair.

      If Repair isn’t able to recover your data, pick Extract Data to extract values and formulas from the workbook.
    If neither automatic nor manual repair works, there are some recovery methods that might help salvage your data. You can also take some preventive measures to avoid losing your work by automatically saving a backup copy of your workbook or creating a recovery file from time to time.

    For more info or you have any query you can also join advanced excel course
  6. LorettaParks

    LorettaParks New Member

    Messages:
    9
    I am going to share few solutions to repair corrupt Excel file:

    Solution 1: Open and Repair

    This is inbuilt option to repair an Excel file. To use this:
    • Open MS Excel instance
    • Navigate on File->Open
    • Select the file which you want to repair
    • Choose ‘Open and Repair’ option
    • Click Repair
    Solution 2: Extract data

    Follow 4 steps of the above solution and click on the Extract data insisted of repair.

    Solution 3: Delete COM Add-Ins

    COM Add-In could be the reason of the file error. Run excel in safe mode and try to open the corrupt excel file. If you are able to open Excel file in safe mode then, its time to delete COM Add-Ins. To do so:

    • Open Excel instance
    • File->Options->Add-Ins
    • Select COM Add-Ins (Under manage drop-down list)
    • Click Go
    • Delete unwanted and save the changes.
    Solution 4: update trust center setting

    • Open Excel
    • File->Options->Trust Center
    • Click on Trust Center Setting button
    • Under protected view option, disable all three options
    • Save the changes
    So, these are the most simple and effective ways to repair corrupt Excel file. If these options won’t work then, you can repair your corrupt file by using Excel file repair software.

    Good Luck!

Share This Page