why would a large addin save in 2 seconds or 18 seconds

[bmurphy]

I have a 2.5 MB addin that I work on quite a bit (I use CodeCleaner on
it every so often).

On my primary computer, a desktop, I have excel 2002, and saving the
file takes about 18 seconds.

On two laptops I have excel 2003, one with no SP and one with SP2, and
saving the file takes 2 seconds! A huge difference.

I just installed excel 2003 SP3 on my primary computer, and save time
only improved a little, to around 14-15 seconds.

Can anyone suggest why such a huge difference in save times? I'd sure
like to get the desktop to save the file in 2 seconds.

All the above computers run Windows XP. The save times are quite
consistent and repeatable, pre-compiled or not.

 

[Gord Dibben]

Probably nothing to do with the add-in.

Your desktop computer may have TIF and Temp folders full.

Do a cleanup of these folders and see if any improvement.


Gord Dibben MS Excel MVP

 

[Charles Williams]

Some things to look at:
- Antivirus checking
- Large number of files in your Temp directoey
- Google Desktop Search
- Addins installed
- Personal.xls

regards
Charles
__________________________________________________
Outlines for my Sessions at the Australia Excel Users Group
http://www.decisionmodels.com/OZEUC.htm

 

[Gary Keramidas]

assuming you're saving to a local drive, you can try this and see if it
makes any difference

go into device manager and expand disk drives
right click the drive and choose properties
click the policies tab and make sure write caching and advanced performance
are enabled .

just read the descriptions so you are aware of what can happen.

i know a lot of times i could save a file to my server faster than i could
save it locally.

 

[bmurphy]

Thanks very much for the suggestions.

I gather that no one has experienced the same thing I am seeing.

I just tried all the suggestions.
Device manager was already set to do caching.
Emptied TIF (temporary internet files) and the Temp folder.
I used Disk Cleanup to do this, and checked to make sure it did it.
Emptied Recycle bin.

This didn't seem to make any difference. Still takes about 15
seconds.

BTW, when I start the save process, I can see the Excel statusbar
which says "Saving myaddin.xla." The progress indicator is visible,
but doesn't show any progress until the very end when it very quickly
runs through the entire length of the progress bar.

I have uninstalled and reinstalled office 2003, but this made no
difference.

I wonder what the heck it could be?

 

[bmurphy]

I forgot to add that there is no antivirus software running.
I don't have Google Desktop Search. I use X1 and it's also on one the
laptops with a fast save time.
There are no Addins installed.
My Personal.xls file is the same on all computers.

I just uninstalled office 2003, and then installed just excel 2003.
With no service pack, save time is still slow. I installed SP2 just
downloaded from MS. With that installed save time still slow.

I tried going through task manager and shutting down all unnecessary
processes. No affect on save time.

I watched the CPU time in Task Manager during the save operation,
which lasts 11-15 seconds. "System Idle Process" is around 98% the
entire time. Excel %CPU never goes above 3%.

Something weird is going on!

 

[Gary Keramidas]

is all disk access slower on the desktop? maybe you have a drive going bad. try
saving to a flash drive or something.

 

[bmurphy]

The desktop is a couple of years old, and I think it runs fine. I use
it daily (Intel 820 D). Other than this file saving thing with Excel,
I don't think it's any slower than the others.

I also have a Toshiba laptop several months old running Vista with
excel 2003 and excel 2007 installed. xl2003 takes 10-11 seconds and
xl2007 takes 8-9 seconds to save the file.

Some years ago now, from the very first time I worked with xl2003 on
one of those other computers, I was amazed by how much faster it saves
addins.

Has anyone else experienced this speed up with xl2003? If not, then
maybe it is my computer.

Brian