How can I successfully repair charcoal drawings

Repair a damaged workbook

If you open a workbook that has become corrupted, Excel will automatically start in file recovery mode and an attempt will be made to reopen the workbook and repair it at the same time.

However, Excel cannot always start automatically in file recovery mode. If you cannot open a workbook because it has been corrupted, you can try to repair the workbook manually.

You can also try other methods to restore the workbook data if a workbook cannot be repaired successfully. As a preventive measure, you should save your workbook as often as possible and back up each time you save it. Alternatively, you can specify that Excel should automatically create a recovery file at certain time intervals. That way, if the original is accidentally deleted or damaged, you'll always have access to a working copy of the workbook.

Manually repair a damaged workbook

  1. Click the tab file on to open.

  2. Excel 2013 or Excel 2016, click the location where the table is located, and then click Search.

  3. In the dialog box, choose to open the damaged workbook that you want to open.

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

  5. Do one of the following:

    • click on Repairto restore as much workbook data as possible.

    • click on Extract datato extract values ​​and formulas from the workbook if errors occur while trying to repair the workbook.

Recovering data from a damaged workbook

The following methods can help you salvage data that might otherwise be lost. If one method doesn't work, you can try another. You can also try third-party software solutions to try to recover workbook data if you cannot recover your data using these methods.

Important: If a disk or network failure prevents a workbook from opening, move the workbook to another disk or off the network to a local disk before attempting any of the following recovery options.

  • To recover data when the workbook is open in Excel, please do the following:

    • Restore the last saved version of the workbook If you are editing a workbook and the workbook becomes damaged before you can save your changes, you can restore the original workbook by reverting to the last saved version.

      To restore the workbook to the last saved version, do the following:

      1. Click the tab file on to open.

      2. Double-click the name of the workbook that is open in Excel.

      3. click on Yesto reopen the workbook.

        Note: The workbook is reverted to the last saved version of the workbook. Any changes that might have caused the workbook to become corrupted have been discarded. For more information about restoring previous versions of a workbook, see Automatically save and restore Office files.

    • Save the workbook in SYLK (Symbolic Link) format By saving the workbook in SYLK format, you may be able to filter out the damaged items. The SYLK format is typically used to troubleshoot printer errors.

      To save the workbook in SYLK format, do the following:

      1. Click the tab file and then on Save as.

      2. Click in the list File type on SYLK (symbolic connection), and then click to save.

        Note: When using the SYLK file format, only the active sheet of the workbook is saved.

      3. If a message appears stating that the file type you selected does not support multi-sheet workbooks, click OKto save the active sheet only.

      4. If you receive a message stating that the workbook may contain features that are not compatible with the SYLK format, click Yes.

      5. Click the tab file on to open.

      6. Select the SLK file that you saved, then click to open.

        Note: In order for the SLK file to appear, it may need to be in the list File type on All files or SYLK files click.

      7. Click the tab file on Save as.

      8. Click in the field File type on Excel workbook.

      9. Enter in the field Filename Enter a new name for the workbook to make a copy without replacing the original workbook, and then click to save.

        Note: Because this format only saves the active worksheet in the workbook, you will have to repeatedly open the damaged workbook and save each worksheet individually.

  • If you cannot open the workbook in Excel, do one of the following to restore the data:

    • Set the calculation option in Excel to manual To open a workbook, try changing the calculation setting from automatic to manual. Since the workbook is not being recalculated, it may be able to be opened.

      To set the calculation option to manual in Excel, do the following:

      1. Make sure you have a new, blank workbook open in Excel. If you don't have a new, blank workbook open, do the following:

    • Click the tab file on New.

    • Click below Available templates on Empty workbook.

      1. Click the tab file on Options.

      2. Click in the category Formulas under the options for calculation on Manually.

      3. click on OK.

      4. Click the tab file on to open.

      5. Select the damaged workbook, and then click to open.

    • Use external references to link to the damaged workbook If you just want to get data and not formulas or calculated values ​​from the workbook, you can use external references to link to the damaged workbook.

      To use external references to link to the damaged workbook, do the following:

      1. Click the tab file on to open.

      2. Select the folder that contains the workbook, copy the file name of the damaged workbook, and then click Abort.

      3. Click the tab file, and then click New.

      4. Click below Available templates on Empty workbook.

      5. In cell A1, type the new workbook = Filename! A1 where the filename is the name of the damaged workbook that you copied in step 2, and then press ENTER.

        Tip: You just need to enter the name of the workbook - there is no need to enter the file name extension.

      6. When the Update values appears, select the damaged workbook and click OK.

      7. When the Select sheet appears, select the appropriate sheet, then click OK.

      8. Select cell A1.

      9. Click the tab begin in the group Clipboard on Copy.

      10. Select a range starting in cell A1 that is approximately the same size as the range of cells containing the data in the damaged workbook.

      11. Click the tab begin in the group Clipboard on Insert.

      12. Leave the range of cells selected and click the tab begin in the group Clipboard again on Copy.

      13. Click the tab begin in the group Clipboard on the arrow below Insert, then click Insert values and then on values.

        Note: Pasting the values ​​removes the links to the damaged workbook and leaves only the data.

    • Use a macro to extract data from a damaged workbook If a chart is linked to the damaged workbook, you can use a macro to extract the chart's source data.

      To use a macro, do the following:

      1. Enter the following macro code in a module sheet:

      2. Add a new worksheet to your workbook and rename it "ChartData".

      3. Highlight the chart from which you want to extract the underlying data values.

      4. Note: The chart can be embedded in a worksheet or on a separate chart sheet.

      5. Run the GetChartValues ​​macro.

      6. The data from the chart is inserted into the "ChartData" worksheet.

Automatically save a backup copy of a workbook

Saving a backup copy of your workbook automatically helps you ensure that you always have access to a working copy of the workbook, even if the original is accidentally deleted or damaged.

  1. Click the tab file on Save as.

  2. Excel 2013 or Excel 2016, click the location where the table is located, and then click Search.

  3. Click the drop-down arrow next to Toolswho is next to the button to save and then click General options.

  4. Check the box Create backup file.

For more information about saving and restoring older versions of a workbook, as well as restoring new workbooks (that have not been previously saved), see Restore Office Files.

Automatic creation of a recovery file at certain time intervals

By configuring Excel to automatically back up your workbook, you ensure that you always have access to a working copy of the workbook, even if the original is accidentally deleted or damaged.

  1. Click the tab file on Options.

  2. Activate in the category to save under Save workbooks check box AutoRecover information will save all of them, and then enter the number of minutes.

  3. Enter in the field AutoRecover file location the desired location for the recovery file.

  4. Make sure to check the box Disable AutoRecover for this workbook only is not activated.

For more information about saving and restoring older versions of a workbook, as well as restoring new workbooks (that have not been previously saved), see Restore Office Files.

Do you need more help?

You can always ask an expert in the Excel Tech Community, get support from the Answers Community, or suggest a new feature or improvement on Excel User Voice.