Excel.exe has generated error and will be closed by windows

[Delfim Machado]

When I try to open a small excel file (307 kb)with some
links to other files and with graphs I get the following
message.

"EXCEL.exe has generated errors and will be closed by
Windows. You will need to restart the program" An error
log is being created <CANCEL>
I'm working on a corporate PC running on windows NT and
using excel 2000 (9.0.3821 SR-1)
Can u help?

 

[Jan Karel Pieterse]

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

 

[DelfimMachado]

OpenOffice works!! I got the file back with all the links
and it seems that all data is ok. The file wasn't
protected.

Thanks