Dealing with the registry keys settings is a very sensitive task and hence needs to be handled with care. The data corruption in Excel workbooks is a very common procedure that could happen due to several reasons like application malfunctioning, virus attack, unexpected system shutdown and lots more. But Ms Excel contains a feature through which you can extract data from corrupted Excel workbooks in some of the instances. And for rest of the instances in which the Excel corruption is more, there no other way to have Excel Repair software.
To do this you can manually start the process by clicking ‘Open’ on the ‘File’ menu and then a window appears in which you have to click the arrow on the ‘Open’ button and then click ‘Open and Repair’ after selecting the required file to be repaired.
The registry values that affect data recovery depend upon the file version of Excel that you are using as for example for Excel 2002 it is:
HKEY_CURRENT_USER\Software\Policies\Microsoft\Office\10.0\Excel\Options
And for Excel 2007 it is:
HKEY_CURRENT_USER\Software\Policies\Microsoft\Office\12.0\Excel\Options
The extraction of the data depends on the status of ExtractDataMode, if it equals to 2, then it shows that everything is fine and then Excel tries to extract whole of the workbook including formulas, formatting etc. but in case if it equals to 1 then the workbook is corrupted and Excel extracts only the data. To change the value of ExtractDataMode from 1 to 2, you need to modify the registry keys in the Registry Editor, but beware as any of the wrong handling to them can lead to further corruption in workbooks which can not be repaired by this method and the only solution is Excel repair software. For this you have to locate the corresponding registry key in the Registry Editor and then modify it.
This is a task of a perfect user who knows all the whereabouts of the registry keys but sometimes most of the other users also attempts to do so and fall in other serious problems of Excel file corruption. And even in most of the cases working the above method correctly do not solve the problem and the corruption in the workbooks still persists. So in these cases you need an Excel Repair which can be done by Excel Repair software. These Excel Repair software are able to repair the workbooks in an effective manner. The algorithms applied by these Excel Repair software are proficient in Excel Repair in any of the cause.
Stellar provides one of the best Excel Repair software called Stellar Phoenix Excel Recovery software. This is the topmost Excel Repair software ever known since. This Excel Repair software extracts the maximum data possible from the corrupted workbooks after a thorough scan of them. The file version is not a problem with this Excel Repair software as it is compatible with all of them including Excel 2000, 2002/XP, 2003 and 2007.
The Excel workbooks with tables, URL’s, images, charts, formulas, and hyperlinks are repairable with this Excel Repair software with much ease. Its demo version, which is available on the company’s website, previews you all the repairable files.
