Excel crashes over and over again

[Martin Andreasson]

Hi,

I have a problem with Excel 2002 running on Windows XP
with SP1 installed. I have all the latest patches for
Office and Windows.

The thing is that Excel keeps on crashing in certain
documents whatever i do. This is the error msg:

"Faulting application excel.exe, version 10.0.5815.0,
faulting module excel.exe, version 10.0.5815.0, fault
address 0x006fb9ef."

In event viewer there is also another msg that says "Fault
bucket 71133644".

I have tried to uninstall and then install Office, didn´t
work so i reinstalled the whole computer but the problem
is still there. It´s a document containing som macros and
is probably rather heavy for the computer. But there are 8
other people in that department and none of them are
having any problems. It´s just this computer.

Anyone has any ideas?
Rgds
Martin

 

[Jan Karel Pieterse]

Hi Martin,

The thing is that Excel keeps on crashing in certain
documents whatever i do. This is the error msg:

"Faulting application excel.exe, version 10.0.5815.0,
faulting module excel.exe, version 10.0.5815.0, fault
address 0x006fb9ef."

Sounds like a file corruption to me.

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

 

[Guest]

Thx alot for your help!
The thing is that the very same files works fine for 6-7
other people, it´s just on this one computer that Excel
crashes. And on that comp is where i have reinstalled
office and tried almost anything i can come up with. I
finally reinstalled WinXP. But it still crashes.

Sometimes he can work for a day or two but then all of a
sudden it crashes again. Could it be that the comp is too
weak? It´s a portable PIII 800 with 256 RAM. Sholud be
enough i think.

COuld it be one of the latest updates to Office that makes
this problem occur? Is one solution to reinstall office
and don´t add the updates?

I´m just running out of options =)

/ MArtin

-----Original Message-----
Hi Martin,

The thing is that Excel keeps on crashing in certain
documents whatever i do. This is the error msg:

"Faulting application excel.exe, version 10.0.5815.0,
faulting module excel.exe, version 10.0.5815.0, fault
address 0x006fb9ef."

Sounds like a file corruption to me.

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

.

 

[Jan Karel Pieterse]

The thing is that the very same files works fine for 6-7

other people, it´s just on this one computer that Excel
crashes. And on that comp is where i have reinstalled
office and tried almost anything i can come up with. I
finally reinstalled WinXP. But it still crashes.

I still suspect a file corruption.

I have seen files working fine on system A crashing system B. Mostly
due to file corruption in combination with specific XL versions and
service releases.

Of course a PIII 800 with 256 MB isn't a very comfortable combination
for Win XP, but it should (just) suffice.

Adding RAM would help improving performance, but I strongly doubt it
would prevent the trouble with the workbook(s).

Regards,

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