no speed kills

D

David Rosenberg

I am having great difficulty with the speed of working on
excel worksheets. My file is 38kb. I tried my first
macro and may have also imported some files that take
quite a long time to process. I have done defragmenting
and other system enhancements. When I have this large
file open, steps that normally take less than a second
take 30 seconds to a few minutes, hampering progress.

Is there a way to reduce the file size, find the culprits
or improve this issue?

Thanks!
 
N

Norman Harker

Hi David!

With 35kb it's unlikely to be file size that is the problem. More
likely an overfull C:\Windows\Temp or a bloated Excel.xlb is the
cause:

The most likely cause is that a vital area of the system used by Excel
is full of junk and needs clearing out.



Close down and re-open the computer just to make sure that all
installations

are complete.



In Windows 95/98 and ME



Delete all files in C:\Windows\Temp





In Windows NT/2000/XP



Find and Select C:\Documents and Settings\<user>\local settings\temp





They are left behind by installing programs but Excel needs the space.



Try again with Excel.



Bloated xlb File


Next is that with pre 2002 versions of Excel there is a tendency for
the toolbar file to bloat in size and eventually this can cause
crashes on opening. It is usually preceded by Excel being noticeably
slower than before in opening and in performance generally. Generally
this means deleting the bloated file.



Next:



Using Start > Search > For Files and folders



Locate the Excel.xlb or Excel10.xlb file. If it is above around 30kb
rename

it Excelxlb.old and move it somewhere. If it's very large you probably
won't

be able to do much with it anyway. This is the toolbar file and Excel
will

create a new one for you.



Now try again.



Microsoft Knowledge Base on Quits after Opening Problems


Next work through the following Knowledge Base articles that cover
this problem that is associated with recent installations and / or
application of service releases.



http://support.microsoft.com/default.aspx?scid=KB;en-us;224432

OFF2000: Program Quits Immediately After Starting



http://support.microsoft.com/default.aspx?scid=kb;EN-US;236592

OFF2000: Error Messages Starting Office Program, or Program
Immediately Quits on Windows XP, Windows NT 4.0, or Windows 2000



http://support.microsoft.com/default.aspx?scid=kb;EN-US;255503

OFF2000: Program Quits Immediately After Starting When SR-1/SR-1a
Update Is Applied



http://support.microsoft.com/default.aspx?scid=kb;EN-US;267968

OFF2000: Program Quits After You Update from SR-1/SR-1a Administrative
Installation



http://support.microsoft.com/default.aspx?scid=kb;en-us;257593

OFF2000: Programs Quit Immediately on Windows 2000 When You Are Logged
on as User



http://support.microsoft.com/default.aspx?scid=kb;EN-US;270125

OFF2000: Program Quits Immediately After Installing Project or Visio







Maybe you could find something at Charles Williams' site:
http://www.decisionmodels.com

And David McRitchie has some notes at:
http://www.mvps.org/dmcritchie/excel/slowresp.htm


--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top