Excel 2000 Problem

[Marek]

Hi,

I have a client running some excel documents on Excel2000 on a Win98
Machine.
The files are 2mb+ with lots of links.
"Sometimes" when opening the following error comes up :

EXCEL caused an invalid page fault in
module EXCEL.EXE at 0167:300a22ae.
Registers:
EAX=00030030 CS=0167 EIP=300a22ae EFLGS=00010206
EBX=00000000 SS=016f ESP=0062a4fc EBP=0062a56c
ECX=021c0080 DS=016f ESI=021f00bc FS=12ef
EDX=00000010 ES=016f EDI=0062ce70 GS=0000
Bytes at CS:EIP:
8b 44 08 0c 89 45 dc 0f bf 07 47 89 45 e0 47 0f
Stack dump:
00000000 0000201e 0062ae50 82a7fad8 3069f9c0 00000000 0062a524 0062a530
3003b5c2 3069d9c0 00002000 3069d9c0 00038000 0062c02e 3003b403 3069d9c0

It also comes up saying the files are locked for editing - but no-one else
is using them.

The PC has plenty of grunt even though its a Win98 box.

When the files are opened on another machine (XP running Excel97) there are
no problems.

Anyone have any ideas?!

Thanks
Marek

 

[Dave Peterson]

Just some things to try...

Try opening excel in safe mode:
close excel
windows start button|Run
excel /safe
file|Open your workbook

Does it still cause a problem?

If no, then maybe it's your *.xlb (where excel keeps your customized toolbar
changes) that's causing the trouble.

Close excel
windows start button|find|*.xlb

rename all you find to *.xlbOLD

Then restart excel (normally) and open your workbook.

If that fixes the problem, delete all those *.xlbOLD files and recreate any
changes to your toolbar.

 

[Marek]

Hi Dave,

She gave that a try - same problem...

Any other ideas?

Marek

 

[Dave Peterson]

I think you're gonna have to do some detective work.

Maybe it's the workbook, maybe it's really excel.

If it only occurs with this one workbook, then I'd bet it wasn't excel. If it
happens with other workbooks, too, then maybe Help|Detect and repair (or
reinstalling) would help.

If it's only this one workbook, then maybe it's the workbook that's corrupted.
It seems like each version of excel is sensitive to slightly different stuff.
(xl2k could have trouble, xl2002 may not--in fact, lots of people have reported
that xl2002 can open files that xl97 or xl2k couldn't.)

Maybe you could try to find a copy of xl2002+ to see if opening|saving it there
would help.

And if it is a corrupted workbook, you may want to try openoffice. Lots of
people have said that it's recovered workbooks that excel couldn't.

(http://www.openoffice.org, a 60-65 meg download or a CD)

If the file is really important, there are commercial recovery services. I've
never used it, but you might want to check into:
http://www.officerecovery.com

===
Yep. I don't have any real insight to why sometimes good workbooks get
corrupted.