Excel - corrupted excel file data recovery

While trying to open my saved Excel file was getting error message - The File is corrupted and cannot be opened.

I tried running Open and repair utility but nothing worked, the error still appear every time when i try to open the saved excel file.

Then i searched the web for the solutions to fix the error and found some articles. I tried the solutions given, I am glad it worked for me and I was able to recover my Excel workbook.

Helpful article - Recover corrupted Excel file data



Degitial marketing Head

To repair corrupt Excel file, I would like to refer an excellent third party software, Kernel for Excel repair. The software is designed with a secure and advanced algorithm to deal with any kind of situations. For more information, visit- https://www.kerneldatarecovery.com/excel-recovery.H T M L


You may have tried various methods to recover corrupt excel file. Here, are a few  manual steps recommended  for you to try out:

Restoring corrupted excel files manually

  • Open MS excel spreadsheet and may find a blank sheet.
  • Get file menu opened  and then, press on open or just click Ctrl+O.
  • After  finding the  required file just  select open and repair from “open button drop down menu”.
  • If still unopened , press on extract data and press yes.

You can also get further information on the given link below:



In order to recover a corrupted excel file, you can also download the Bitwar Data Recovery software. This tool has strong functions and supports recovering many files types from various devices. https://www.bitwar.net

Freelancer IT Consultant

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.


To Recover data when the workbook is open in Excel

  • Revert the workbook to the last saved version    If a workbook becomes corrupted while you work but before you save your changes, you can revert your workbook to the last saved version:

    1. Click File > Open.

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

    3. Click Yes to reopen the workbook.

      The workbook opens without any changes you made that might have caused the workbook to become corrupted.


If you are looking for a solution that will help you in excel recovery than I would say first you must go with a manual solution and if it doesn't work then only choose third party solution. Now don't worry where you will get manual solutio. I am aware of the article in which you will get to manual tricks and a reliable software solution. Simply go with the link to know  how to fix “excel errors were detected while saving” issue in Excel 2010, 2013, 2016.




Your are not logged in . Please login to post replies

Click here to Login / Register