Excel spreadsheets are stored in XLS format, this file format is widely acclaimed in the global corporate environment. Right from a marketing professional to an accountant, Excel files are used for tabulating and calculating entire routine work. Although, there are situation when user confront with serious damage in their.xls files, the application can get struck in middle and makes entire user data inaccessible.

Damage issues can vary, in some cases the user is unable see or make changes in the Excel file data or it becomes completely orphaned. Therefore, it is advisable to make use of a backup file available for Excel data. This can help user in retaining data and making it accessible for users. In any case if the backup of data is unavailable user can make of use of automatic recovery option which repair the Excel damage and reopen the document.

To make use of automatic repair tool the following steps can be undertaken:

1. Click Open on the File Menu.

2. Go to the Open dialog box and make selection for the file to be opened, now click the arrow next to the Open button.

3. Choose open and repair and select the method required to recover the workbook.

The above method has proved to be beneficial in several cases of Excel corruption, but sometimes disk or network error restrict user to open the file. For this, file should be removed to a different hard disk drive before the recovery methods are initiated. Read the rest of this entry »