Microsoft Excel has encountered a problem...

F

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
 
J

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.
 
F

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
 
J

joel

Check the event viewer to seee if any events werre logged

Control Panel - Adminstrative Tools - Event viewer.
 
F

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
 
Joined
Jul 13, 2009
Messages
3
Reaction score
0
I've been having the same problem with files containing pivot tables. I just now discovered a pattern to this: If I open the Excel and then open the problem workbook from Excel's openfile dialog, I can crash it every time by selecting a value in one of the page fields of a pivot chart and then clicking on a resulting chart element (line, gridline, etc). If instead I open the file by double-clicking on it in Windows Explorer, the crashes are much less consistent.

I can't explain why, unless possibly the common dialog calls are getting left in memory and then later get corrupted by the pivot table code, but at least I've discovered a pattern.
 
Joined
Jul 13, 2009
Messages
3
Reaction score
0
Correction to my last: I just tried the test I wrote about above from another computer (after saving it locally to that computer's hard drive), and got the crash no matter how I opened the file.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top