Leading the way in Microsoft Office Development

In Excel 2002 there is a feature that can repair your damaged or corrupted workbooks.

Select (Help > Detect and Repair)

If you have a corrupted workbook then you can use the Open and Repair command that is available from (File > Open)(Options menu). It is best to try the Repair button first and then failing that try the Extract Data button.

All the data in your workbook including all worksheets in the correct order is recovered although only the cell contents is extracted, there is no formatting, charts or any other objects.

If you have a corrupted Excel workbook that will not open you can reference the workbook from another workbook using cell reference. =[corrupted_workbook name.xls]SheetName!A1.

When a workbook is opened some temporary files are created in the same directory or location as the original file (inc. floppy disks). These temporary files are deleted when the workbook is closed, although this may cause Excel to crash if there is not enough free space to accommodate these files.

Restore my shortcuts while repairing -

Discard my customised settings and restore default settings - This will remove any customised toolbars or menus, including any custom views ?? Or macros

The Detect and Repair process can take quite a long time.

You may have to re-enter your personal details (i.e. username and initials) when you restart Excel.

You can also use the "Open and Repair" button on the Open drop-down menu from the (File > Open) dialog box.

There is also an action you can take when Excel hangs (or doesn't respond).

Start > Programs > Microsoft Office Tools > Microsoft Office Application Recovery

click "Recover Application" to try and recover the application click "End application" to close the application with a loss of data.

A document recovery task pane will appear.

If an error does occur Excel should prompt you to save your changes before the application is closed.

Any files that say [Recovered] against their file name are usually more recent than those that have [Original] against their file name.

The AutoRecovery is guaranteed to recover any lost work in the case that Excel crashes. Excel will recover any unsaved files after a crash. If Excel hangs you can try the MOAR help application (Start > Programs > Microsoft Office Tools)

The document recovery pane displays all files that were recovered from the previous Excel session.

After each file name there will be square brackets indicating whether the file is the original file or whether it is a receovered file.

When you select a file a drop-down menu will appear.

This will allow you to open, save as, delete or show repairs for that particular file.

Selecting the actual file will open it.

By default Excel saves information for document recovery every 10 minutes.

This interval can be changed from the (Tools > Options)(Save tab)

SS

Make sure the "Save AutoRecovery" checkbox is selected.

You can enter an interval between 1 and 120 minutes.

If the word original appears in the square brackets then the file has not been recovered and will only contain the changes up to the last time the workbook was saved.

SS - Document Recovery window

It is possible to turn the Document Recovery task pane off by selecting (View > Toolbars > Document Recovery)

If you close the task pane using the small cross in the top right corner, the task pane is only removed temporarily.

Pressing the close button in the top right corner of the task pane will delete any recovered files.

Excel 2003 enables you to recover previously opened files after Excel has crashed.

Excel will analyse every file you had open at the time and will try to fix any errors.

Depending on the extent of the errror which occurred all your files will be recovered.

Excel may even recover data that was not saved.