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:
    179
    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:
    220
    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

Share This Page