TECH TIPS


October 2017: Repair a corrupted workbook




Applies To: Excel 2016 Excel 2013

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.

    Open and repair command

  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.

Compiled and organized from Micsrosoft Office by WOUGNET TECH-Support, there are other options to help save your documents or work while using Microsoft office tools, please follow the link below to learn more and how...

Recover data from a corrupted workbook

Automatically save a backup copy of a workbook

Automatically create a recovery file at set intervals

Latest News

Ensuring access to information on menstrual hygiene management and sexual reproductive health...

Why ICT Policy Making and Advocacy efforts should Advance a Gender-Responsive approach to...

Girls in ICT



Upcoming Events
AI for Good Global Summit 2018
From: 15-May-2018 to: 17-May-2018 Book this event

2018 ICT4D Conference
From: 08-May-2018 to: 10-May-2018 Book this event

Internet Freedom Festival
From: 05-Mar-2018 to: 09-Mar-2018 Book this event

RightsCon Toronto 2018
From: 16-May-2018 to: 18-May-2018 Book this event