Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 575
Default exiting excel takes ages if any add-in loaded

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


  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 6
Default exiting excel takes ages if any add-in loaded

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

In Outlook under ToolsOptionsPreferencesJour*nalling: un-check the
office apps.

Aidey

  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 575
Default exiting excel takes ages if any add-in loaded

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

"aidey" wrote in message
ups.com...
Don't know if this applies to Excel XP, but have you tried:

In Outlook under ToolsOptionsPreferencesJour*nalling: un-check the
office apps.

Aidey


  #4   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2,253
Default exiting excel takes ages if any add-in loaded


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,

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

"aidey" wrote in message
ups.com... Don't
know if this applies to Excel XP, but have you tried:

In Outlook under ToolsOptionsPreferencesJour*nalling: un-check the
office apps.

Aidey

  #5   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 575
Default exiting excel takes ages if any add-in loaded

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" wrote in message
ft.com...

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,

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

"aidey" wrote in message
ups.com... Don't
know if this applies to Excel XP, but have you tried:

In Outlook under ToolsOptionsPreferencesJour*nalling: un-check the
office apps.

Aidey





  #6   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2,253
Default exiting excel takes ages if any add-in loaded


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 :

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

  #7   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 6
Default exiting excel takes ages if any add-in loaded

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.

  #8   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 575
Default exiting excel takes ages if any add-in loaded

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

"aidey" wrote in message
ups.com...
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.



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Exiting Excel MEAD5432 Excel Discussion (Misc queries) 2 December 7th 07 11:05 PM
Loading Excel - please help - takes ages to load Smilersal Excel Discussion (Misc queries) 0 July 12th 06 02:10 PM
loading excel takes ages Smilersal Excel Discussion (Misc queries) 3 July 11th 06 12:13 PM
How do I calculate ages in excel using date of birth & another dat Paniac Excel Discussion (Misc queries) 4 October 18th 05 04:25 AM
How do I calculate ages of employees in Excel? ChakaCaen Excel Worksheet Functions 1 November 15th 04 04:27 PM


All times are GMT +1. The time now is 03:29 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"