Lisa,

Can't answer your question directly, but there were many things I found
several years back that contributed to Excel crashes.

1. Some folders have too much stuff in them -
Temp Folders, especially the ones holding internet Temp files
Recycle Bin
some mail folders
sometimes excess number of unread messages in the newsgroup.
2. Code conflicts -
Have a variable declared as Public and than the save variable
declared as Private or Dim
Using Excel Words as Names in the worksheet and/or in code. I check
this by highlighting
the word and hitting F1. If it is safe to use, Excel won't find
anything in help.
Modules and/Code with the same exact name.
Undetected errors in code
3. Use the compiler in the VBE to check your code. It helps to have Option
Explict at the top of
all modules.
4. Download and use the code cleaner at this site:
http://www.appspro.com/Utilities/CodeCleaner.htm
--
steveB

Remove "AYN" from email to respond
"LisaKan" wrote in message
ups.com...
First of all, I look to this site ALOT and find tons of useful
information here. Thanks!

Here's my problem:

User base has Office 2002 and just received an XP Service Pack 2
install. Suddenly, when using Excel, they are experiencing a generic
'Microsoft Excel has encountered a problem and needs to close...'.
There have been no other recent updates to the spreadsheets.

The spreadsheets they are using all get this error when they click on
an ActiveX button that runs code. The code gathers data from the
spreadsheet and creates a set of xml that then gets sent to a service
on our server.

We found a work around (a real icky one). When we go into the VBE and
select Tools... References... Then 'uncheck' any one of the
references. Click OK. Then, go right back into Tools... References...
and 'check' the same reference. Click OK. Once this has been done,
the spreadsheet works fine. However, this has to be done to EACH
spreadsheet. NOT GOOD. Also, this is not something we want the users
to have to do.

Any idea what caused this to begin with?

Any idea what actually happens when you go through the Tools...
References... dialog? It seems like 'something' get 'recalibrated' in
some way. If we can find out what is happening, maybe that would lead
us to a way to fix this.

HELP!!!