Microsoft Office Excel is an application that allows you to create feature-rich spreadsheets and charts. The application is used in various financial, accounting and commercial area of fields. An Excel file might get corrupt due to reasons like unexpected shutdown, virus attack, application malfunction, Windows issues and network problems. Such events can make your spreadsheet unreadable to read or unfeasible to open. To recover from such situations, MS Excel provides you a method to extract values from such files. You can use external references that might allow you to link to the damaged file. However if the method fails, you can use commercial Excel Repair tools.
If you wish to recover only data and not the whole document, you can use some external references that could link to the file and hence extract out the information.
To do so, use these steps in order:
. Create two new workbooks, file A and file B
. Open the file A and select cell A1 and click Copy of Edit menu
. Open the file B, select cell A1, click Paste Special of Edit menu and then click Paste Link
. Remove the dollar signs from formula by selecting cell A1
. Again, click Copy option while selecting cell A1
. You then need to select an area that is of approximate size as the range of cells containing data in corrupted file is. Click Paste option of Edit menu
. Click Links of Edit menu while this cell range is selected
. You will see a Links dialog box, in which you should select the file A and click Change Source. Next, you will see a Change Links dialog box. Select the corrupted file in this dialog box and click OK. If you see Select Sheet dialog box, select the required file and then click OK
. Click Copy while the cell range is still selected
. Click Edit menu and then Paste Special.
. Next, select Values and click OK
The above steps will extract all the data from the affected Excel file. However, if you desire to achieve complete Excel Recovery results, use advanced Excel file repair tools. Designed with safe file repair technology, these excel repair utilities scan and repair damaged Excel files without changing the data integrity.
Stellar Phoenix Excel Recovery is a comprehensive excel file repair utility for Excel 2007, 2003, 2002 and 2000. It is the finest application to restore all file objects including charts, macros, formulas, hyperlinks, charts, tables and others. It is compatible with Windows Vista, XP, 2003, 2000 and NT.