HELP NEEDED- CORRUPTED FILE

  • Thread starter Thread starter Elisa
  • Start date Start date
E

Elisa

Does anyone know how to open a corrupted Excel file? I am
having problems to open a spreadsheet.
 
Elisa said:
Does anyone know how to open a corrupted Excel file? I am
having problems to open a spreadsheet.

You can't open it if it is corrupted. You will need to get the backup file.

By the way, NEVER use files direct from removable media; this is almost
guaranteed to corrupt them. Copy to hard disk and then open from there. Save
to hard disk and then copy to removable media.
 
Hi Elisa!

You don't mention the version of Excel you have.

Generally, Excel 2002 and 2003 have much greater abilities regarding
opening of corrupted files.

If the file is not protected, maybe you can open it with OpenOffice
(www.Openoffice.org).


--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
-----Original Message-----
Does anyone know how to open a corrupted Excel file? I am
having problems to open a spreadsheet.
.
I've been getting corrupted files a bunch. For some
reason Lotus seams to open them without any problems. You
might loose some formatting but at least you can get at
the data.
 
Besides being asked to provide the version of Excel,
is there any other information you could provide, such as
how you corrupted the file, and when you noticed it no longer
worked, and what you were last doing within the workbook.

You might also take a look at my page on backup and recovery
http://www.mvps.org/dmcritchie/excel/backup.htm#recovery

I would create another directory on your hard drive and copy
every file from the directory you have your dataset in to the
new directory. Make sure you can see file extensions.
There may be an older copy without a file extension.
Don't work directly from files in your new directory, the purpose is
to keep them safe from further harm. Copy from there to
somewhere else for testing.
http://www.mvps.org/dmcritchie/excel/backup.htm#wbrecovery
 
Back
Top