exiting excel takes ages if any add-in loaded

[Robin Hammond]

This has got me stumped.

If I load any add-in, AND then unload it again, then quit excel, it takes
much tool long to quit. The app window disappears but watching it in the
task manager I see about a 90Mb memory bloat and 99% cpu usage for over a
minute. I've tried this with a variety of add-ins - mine as well as Rob
Bovey's, JKP's, solver.xla etc.

Alternatively, if I load excel with no add-ins at all and quit immediately,
it exits cleanly. I've cleared out the registry as best I can, got rid of
any unwanted or old add-ins refs. Tried the new detect and repair tool.
Running Excel XP.

Anyone have any ideas?

Thanks,

Robin Hammond
www.enhanceddatasystems.com

 

[aidey]

Don't know if this applies to Excel XP, but have you tried:

In Outlook under Tools>Options>Preferences>Jour­nalling: un-check the
office apps.

Aidey

 

[Robin Hammond]

Aidey,

Thanks for the idea. Not a bad suggestion but I don't use the journal at
all.

Anyone else with ideas?

Robin Hammond
www.enhanceddatasystems.com

Don't know if this applies to Excel XP, but have you tried:

In Outlook under Tools>Options>Preferences>Jour­nalling: un-check the
office apps.

Aidey

 

[keepITcool]

Robin,

any COMaddins trying to disconnect?

try with "Ignore Other Apps" checked/unchecked (under options/general)

the obvious:
clean temp directory (remove the VBE subfolder?)
less obvious:
a damaged XLB (try to temporarily rename the xlb in
C:\Documents and Settings\USERNAME\Application Data\Microsoft\Excel


use regmon (sysinternals) to see what's happening in the registry
(set filter to include "excel*")

a normal exit would result in 120-200 lines generated.
maybe you can trace if it recursively "hammers" a specific registry
entry.

use FILMON (sysinternals) to see what's happening on the disk.
(havent tried that yet)


--
keepITcool
| www.XLsupport.com | keepITcool chello nl | amsterdam


Robin Hammond wrote :

 

[aidey]

When you say that you don't use the journal, do you mean that the
options in Outlook are unchecked? I was caught out by this even though
I've never even run Outlook, let alone Outlook journalling.

 

[Robin Hammond]

Aidey,

I use outlook but don't enable any journal options.

Thanks for the ideas. It was the toolbar as KeepItCool suggested.

Robin Hammond
www.enhanceddatasystems.com

 

[Robin Hammond]

keepITcool,

Many thanks. That Regmon thing is quite cool!

Excel was hanging on a toolbar registry key. Rebuilt the toolbar, which went
from 40M to 185K, Excel's memory footprint is down by about 60M. Exits in a
flash.

I'll buy you a beer in Amsterdam over the summer. Probably there for a few
days in August if you're around!

Robin Hammond
www.enhanceddatasystems.com

 

[keepITcool]

I've had regmon since the darkages (when i started with win95?)
and it's been usefull.

I'll take you up on the beer!
Contact me when you're in town .. sunny day preferred


--
keepITcool
| www.XLsupport.com | keepITcool chello nl | amsterdam


Robin Hammond wrote :