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

Tech-related violence against women in Uganda

WOUGNET at the 2018 RightsCon, Toronto

Restrictions to freedom of expression online: Joint oral statement at the Human Rights Council...



Upcoming Events
The Annual Members Meeting
From: 07-Jun-2018 to: 07-May-2018 Book this event

ICT training and GPS mapping
From: 07-Jun-2018 to: 14-Jun-2018 Book this event

Gender Mainstreaming capacity building
From: 29-May-2018 to: 09-Jun-2018 Book this event