Excel crashing in NT4

[Steve White]

One of my users is experiencing a problem opening a file
in Excel.

They open the file, choose to "enable macros", the file
begins to open and then a Dr Watson message is presented
saying the an Access Violation has occurred at 0xC0000005
at Address 0x3044ab9e"

Excel has got the Business Objects add-in appluied.

Anyone got any ideas what causes this ?

Have also posted on NT 4 - Apps list. (Before I found this
one


Thanks

Steve

 

[Jan Karel Pieterse]

Hi Steve,

One of my users is experiencing a problem opening a file
in Excel.

They open the file, choose to "enable macros", the file
begins to open and then a Dr Watson message is presented
saying the an Access Violation has occurred at 0xC0000005
at Address 0x3044ab9e"

Excel has got the Business Objects add-in appluied.

Anyone got any ideas what causes this ?

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