Lorein Watson (Executive) 04 February 2019
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
CAclubindia Online Learning offers a wide variety of online classes and video lectures for various professional courses such as CA, CS, CMA, CISA as well as various certification courses on GST, Transfer Pricing, International Taxation, Excel, Tally, FM, Ind AS and more. know more
daisy smith (Degitial marketing Head) 10 April 2019
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
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
You can also get further information on the given link below:
Kassia (free) 30 August 2019
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
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:
Click File > Open.
Click the location and folder that contains the corrupted workbook.
In the Open dialog box, select the corrupted workbook.
Click the arrow next to the Open button, and then click Open and Repair.
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.
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:
Click File > Open.
Double-click the name of the workbook that you have open in Excel.
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
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.
Priyanka Chouhan 18 October 2019
One solution is Open and Repair which is mentioned by AkshayM. Now, another solution is to change the component service.
Read this well-elaborated blog on this error: https://www.stellarinfo.com/blog/file-is-corrupted-and-cannot-be-opened-excel-2010/