File recovery

  • Thread starter Thread starter Peter Downes
  • Start date Start date
Hi,

None that I know of.

Just in case:


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.


Regards,

Jan Karel Pieterse
Excel TA/MVP
 
Thanks for the suggestions.

Tried all but failed. I can view the file with a package called ExcelFix,
but to save it must buy the full package.

This is a result of a HDD crash.

Error is" <file> cannot be accessed. The file may be read-only, or you may
be trying to access a read-only location. Or, the server the document is
stored on may not be responding."

Any other ideas?

Jan Karel Pieterse said:
Hi,

None that I know of.

Just in case:


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.


Regards,

Jan Karel Pieterse
Excel TA/MVP
-----Original Message-----
Is there any shareware utility for recovering corrupt Excel files?


.
Click to expand...
Click to expand...
 
Hi Peter,
Thanks for the suggestions.

Tried all but failed.
Click to expand...

Mail it (zipped) to me, I'll see what I can do with it.

Regards,

Jan Karel Pieterse
Excel TA/MVP
 
Back
Top