corrupted excel 2000 file which is password protected

E

Ezra

we are looking for a utility which will allow us to
recover a excel 2000 file multiple sheets and passworded.
The file was originally stored on a zip disk and we were
not able to open the file because of hardware problems
with the zipdisk. We then used norton disk doctor and
were able to copy the file from the zipdisk to our 'C'
drive. When we now try to open the file with excel, it
asks for the password, which it accepts, but then gives
the following error message
The file is approx 3mb and asks for the password which it
accepts but then says 'excel has generated errors and will
be closed by windows - you will need to restart the
program. An error log is being created.'

We have also tried to open the file using Excel XP but
this only gives us part of the first sheet.

Can anybody make a suggestion.

Ezra
 
J

Jan Karel Pieterse

Hi Ezra,
we are looking for a utility which will allow us to
recover a excel 2000 file multiple sheets and passworded.
Click to expand...

Options to try and open a corrupt file

- Set calculation to manual
- open the file, but disable macros (assuming you've set macro security
to medium: Tools, Macro, security)
- As soon as you've clicked the disable macros button, press
control-pageup or control-pagedown, thus changing sheets.

If that does not work, try creating a link to the file:

='c:\my documents\[MyFileName.xls]Sheet1'!A1

and copy right and down. This at least gets you the worksheets values.

if you don't know the sheet names, enter this:

='C:\PathToFile\[MyFileName.xls]'!A1

and press enter

If XL (2000) is able to extract them, it will prompt you for a sheet
name.

Sometimes the Excel viewer, Word or even Internet explorer (v5) enables
you to open the file and copy information out of it.

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

Also, Excel XP can sometimes repair XL files with trouble.

Finally, sometimes a corrupt file that still can be opened,
can be cured using this method (XL2000 or up):

- Open the file
- Save-as filetype Webpage
- close the file
- Open the html file
- save-as normal Excel workbook.


Regards,

Jan Karel Pieterse
Excel MVP
www.jkp-ads.com
 
F

Frank Kabel

Hi Jan
thanks for the info.
Re: Excel 2003: IMHO not really better than Excel 2002 in respect to
corrupted files
 
Top