The Open and Repair feature (go to File > Open, and click Browse) is the first option for normal users to repair their corrupt Excel files. In many cases, it works. But when Excel faces serious issues, users may have to attempt some other options or try third-party Excel recovery tools. Let us go through these simple options.
Solve the issues with a working Excel file
Excel files may become corrupt while they are being used. In that case, don’t try to save the changes to Excel. Just reopen the Excel files from File > Open. The file opens again without any issues, but the file will not have the data after the last saving.
Solve the Excel inaccessibility issues by changing the calculation option
Changing the calculation option from ‘Automatic’ to ‘Manual’ may fix some issues with the Excel. It can be done from the Formulas tab of the Excel Options dialogue box (can be opened by clicking File > Options).
Note: If the Excel file is inaccessible due to network/disk errors, copy it to a different drive or disk before attempting recovery.
A precaution against Excel corruption
As a precaution against Excel corruption, one can configure automatic backing up of the Excel file. This can be done from Tools > General Options in the Save As dialogue box (select File > Save As, and click Browse). When the General Options dialogue box appears, select Always create backup checkbox and click OK.
How to recover Excel data when the inbuilt features fail?
While using the inbuilt Excel recovery features, one has to try many methods one after the other till the Excel data is recovered; the recovery can fail too. But in third-party tools like Kernel for Excel, the recovery procedure is very simple and straight forward. This tool recovers data from multiple XLS and XLSX files irrespective of the Excel version. So many Excel users prefer this tool over the inbuilt features.
For more detail click here – http://www.free.repairexcel.net