Hi,

=============

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-----
>I am attempting to open a previously saved workbook but a
>program error is appearing. It states: EXCEL.exe has
>generated errors and will be closed by Windows, yada yada
>yada. An error log is being created.
>
>Does anyone have a resolution to this problem?
>.
>

Hi!
I'm having the same issue as Todd and tried the various
methods you suggested to no avail. Is there any other way
to retrieve this data as my client stands to lose 3 days
data in a 1MB, very complex excel spreadsheet.
When I tried to creat a new document and link to it (as
you suggested) all I got was a "0" or the name of the
company, in the cell A1.
This spreadsheet was working 3 days before hand.
HELP!

Thanks,

Chris
>-----Original Message-----
>Hi,
>
>=============
>
>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-----
>>I am attempting to open a previously saved workbook but
a
>>program error is appearing. It states: EXCEL.exe has
>>generated errors and will be closed by Windows, yada
yada
>>yada. An error log is being created.
>>
>>Does anyone have a resolution to this problem?
>>.
>>
>.
>

Hi Chris,

> Hi!
> I'm having the same issue as Todd and tried the various
> methods you suggested to no avail.

Send me the file (ZIPPED please). I'll have a look.

Regards,

Jan Karel Pieterse
Excel TA/MVP