Excel - corrupted excel file data recovery


Lorein Watson (Executive)     04 February 2019

Lorein Watson
Executive 
 21 points

| My Other Post

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

 

 

daisy smith (Degitial marketing Head)     10 April 2019

daisy smith
Degitial marketing Head 
 24 points

View Profile | My Other Post

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

Andy Roberts (Accountant)     25 April 2019

Andy Roberts
Accountant 
 22 points

View Profile | My Other Post

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:

http://www.repairms*xcel.com/blog/excel-xls-xlsx-file-recovery

Kassia (free)     30 August 2019

Kassia
free 
 24 points

View Profile | My Other Post

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

 

Akshay_M (Freelancer IT Consultant)     03 September 2019

Akshay_M
Freelancer IT Consultant 
 36 points

View Profile | My Other Post

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.

priyankaarya (SOFTWARE DEVELOPER)     06 September 2019

priyankaarya
SOFTWARE DEVELOPER 
 22 points

View Profile | My Other Post

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.

http://www.articleted.com/article/167688/14551/How-to-fix-%E2%80%9Cexcel-errors-were-detected-while-saving%E2%80%9D-issue-in-Excel-2010--2013--2016

avater

Priyanka Chouhan   18 October 2019

Priyanka Chouhan

 2 points

View Profile | My Other Post

One solution is Open and Repair which is mentioned by AkshayM. Now, another solution is to change the component service. 

  1. Click ‘Start‘ or ‘Win+R’ and type ‘dcomcnfg‘ and press ‘Enter
  2. In the navigation pane, expand the ‘Component Services‘ and then, expand ‘Computers
  3. Next, right-click on ‘My Computer‘, and then click ‘Properties‘. ‘My Computer Properties’ dialog box appears
  4. Click on ‘Default Properties‘ tab and then set the following values:
    • Default Authentication Level: Connect
    • Default Impersonation Level: Identify
  5. Click ‘OK’ to change ‘Default Properties

Read this well-elaborated blog on this error: https://www.stellarinfo.com/blog/file-is-corrupted-and-cannot-be-opened-excel-2010/

 


Leave a reply

Your are not logged in . Please login to post replies

Click here to Login / Register  




Popular Discussion


view more »