Corrupt file

D

Danny

Need to know if there is any software or way to recover a
coruppted file.I am in excel 2002 version and it tries to
recover the file but does a poor job HELP!!!!

thnx a bunch,
Danny
 
T

TK

Danny,

You can usually recover the data in a corrupt workbook by
using formula references from another sheet, but this will
not help much with formulas, vba code or formatting.

Your new spreadsheet would consist of formulas something
like:

='[CorruptWorkbookName.xls]CorruptSheetName'!A1


which you can copy to as many rows & columns (and sheets)
as needed to retrieve the data from the corrupt workbook.

This is not a pretty solution, but may be useful as a last
resort... I guess it depends on what you mean by a "poor
job" done by the Excel file recovery.

Good luck!

Tom
 
Top