HELP: Need to recover damaged spreadsheet

  • Thread starter Thread starter Richard White
  • Start date Start date
R

Richard White

"Someone" has prepared a spreadsheet on a floppy (of all things!) and no backup anywhere.

The XLS file on the floppy is corrupt, and Excel won't open it.

Q1. Is there a recovery tool/option?

Q2. I've been able to copy out the RAW data with Hex codes (07) separating the individual cell
values. Is there a way of importing that? I can't see how to specify control code 07 as a
separator character.

Any other options???
Eg. Can I find/replace code 07 by tab etc., and then import??

Many thanks.
 
Richard White said:
"Someone" has prepared a spreadsheet on a floppy (of all things!) and no
backup anywhere.

The XLS file on the floppy is corrupt, and Excel won't open it.

Q1. Is there a recovery tool/option?

Q2. I've been able to copy out the RAW data with Hex codes (07)
separating the individual cell
values. Is there a way of importing that? I can't see how to specify
control code 07 as a
separator character.

Any other options???
Eg. Can I find/replace code 07 by tab etc., and then import??

Many thanks.
Click to expand...
Depends on what the damage is.
If it's damage in the disks directory, something like DOS chkdsk or scandsk
might recover it.
Or an (older) copy of Norton Utilities.
There are various (free ware) search and replace tools available, you
*might* be able to replace the seperators with a ',' and import *some* of
the file using a CSV import.
Failing that, get the idiot who stored the only copy on floppy to re-key it
over the weekend!
 
There's a very good chance I can recover this data for you

If it's not sensitive data, drop me an email and I'll see what I ca
do..

balazs [at] excelforums [dot] co

Cheer
 
If you can find a copy of Excel XP or Excel 2003 then you can try using the Open
and repair option (little dropdwon arrow on the Open button on the File/Open
dialog box), or failing that you could try downloading OpenOffice which will
usually open most corrupt Excel files I have come across.

www.openoffice.org
 
Back
Top