Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]() 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
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]() 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
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Exiting Excel | Excel Discussion (Misc queries) | |||
Loading Excel - please help - takes ages to load | Excel Discussion (Misc queries) | |||
loading excel takes ages | Excel Discussion (Misc queries) | |||
How do I calculate ages in excel using date of birth & another dat | Excel Discussion (Misc queries) | |||
How do I calculate ages of employees in Excel? | Excel Worksheet Functions |