Page Faults

[NeilFarrow]

Dear Whoever,

I have a multi sheet workbook in Excel 97 which is just
over 1.4mb in size. One of the sheets is already 2738
lines long and I want to insert a further 760 lines of
similar data.

However, particularly when I try to save, it keeps
crashing with the "Excel has caused and illegal operation'
error message and displaying the following details:

EXCEL caused an invalid page fault in
module MSO97.DLL at 0167:306c2669.
Registers:
EAX=00000000 CS=0167 EIP=306c2669 EFLGS=00010246
EBX=00000000 SS=016f ESP=0062c66c EBP=00000001
ECX=00020000 DS=016f ESI=00000000 FS=1a2f
EDX=00006f02 ES=016f EDI=00000004 GS=0000
Bytes at CS:EIP:
66 8b 73 06 81 fe fe ff 00 00 0f 84 81 00 00 00
Stack dump:
306c261b 027d6e20 306c261b 00000000 00020b1a 306c2665
00000000 3017ef57 00020b1a 00000004 00020000 00020000
3008eff8 027d6e20 00000000 3011faf9

Free beer for life for anyone who can help me solve this
one.

Regards,
Neil Farrow

 

[Jan Karel Pieterse]

Hi NeilFarrow,

However, particularly when I try to save, it keeps
crashing with the "Excel has caused and illegal operation'
error message and displaying the following details:

Seems like this file is corrupt somehow.

I would :

- make a backup copy
- delete sheets one at the time until it starts behaving
- try to save-as the offending sheet to some older format, like Lotus
WK1
- Open a fresh empty workbook, copy the sheets that did work OK into
that, read the exported (single sheet-) file back in and copy its sheet
back into your workbook.

Regards,

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

 

[Neil Farrow]

Thanks. hda already tried all that, though. Got it
working but only after installing Excel 2000.

Thanks again though.