Microsoft Excel has encountered a problem...

[Frank]

Hello All - So the PC is a windows xp pro sp2 and office xp (2002). The file
normally sits on a server share and whenever ONE client opens file - even
when copied to client's computer and renamed to something else- after
modifying it - adding a letter or two- and at the moment of saving it, excel
crashes with the following message:
Microsoft excel has encountered a problem and needs to close. Microsoft
Excel can try to recover it for you" and further in the Windows that "the
information you were working on might be lost. Microsoft excel can try
recover it for you". A check box with "recover my work and restart Microsoft
excel.
Some things done, searched for xlb files and found none on the system,
gupdate /force and sync executed, chkdsk /r ran as well, started excel with
the /o and /regserver switches as per kb 291288 and same thing. The excel
folder renamed in the registry and same error. Lastly, a new computer set up
with a different PC name and the issue continues...what gives??
yes, the event viewert was checked and it does point to some dll:
AppName: excel.exe AppVer: 10.0.6850.0 ModName:
excel.exe

ModVer: 10.0.6850.0 Offset: 00023c3a

Really not much helpful information.
Thanks for your help.
Regards

 

[joel]

You may not have enough memory on the PC to open the file. I suspect the
file opens from other computers and not others. Try deleting some sheets
from the workbook to reduce the size and see if the problem gets fixed.
Often excel file mysterously grow larger than they need to. There are
methods that people use to reduce excel files that have grown too large.
Other solution, put more memory into the computers that can't open the files.

 

[Frank]

Thanks Joel.

This is not a memory issue though. The client had a good desktop to
beginwith and was given a much better one with enough memory (it's not a
Vista system).

Also, something noticed, it seems that it happens sporadically to other
users although not as frequent as this specific client and, it created these
additional files - wherever the excel file is located- that look like temo
files named like ef000, etc.

Thanks again

 

[joel]

Check the event viewer to seee if any events werre logged

Control Panel - Adminstrative Tools - Event viewer.

 

[Frank]

As odd as this may sound, while doing some research on this never ending
issue, came across a post mentioning that sometimes having a local HP printer
as the default can cause this error in Excel. Mind you the client was not
having the issue when attempting to print, just when she saved or modified
file. Odd but after changing the default printer to another non-local-non-hp
printer, the excel is working just fine.


Thanks