View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Seanie Seanie is offline
external usenet poster
 
Posts: 202
Default Macro Running very slow

On Mar 7, 11:06*am, joel wrote:
there are two things that may be causing the probelm

1) Do you have a delay of around 45 seconds when you open any of the
Microsoft Produccts including excel. *the file system Indexing may have
been truned on which caused delays in opening excel. *I know how to fix
this problem.

2) Did you change anything on your PC like upgrade to Office 2008, or
changed from From XP to either Vista or windows 7? *Office 2008 is much
slower than 2003. *Microsft was working on some fixes. *so make sure you
have all the latest upgrades.

3) Your may have a memory problem on your PC or a hard disk Problem.
Your hard Drive could be fragmented or running out of space. *run a
speed disk utility to fix the hard drive. *You may also be low on your
temp folder on your PC. *Delete any temp file you don't need and your
Waste Basket.

--
joel


Thanks Joel

On (1) not 45 seconds everytime, but certainly sometimes, how can I
check the indexing

On (2) Running Office 2007 on Windows Server 2003, have all available
updates

On (3) How can I check the temp folder and then clear it? I run
Terminal Services, so all runs on the server, no hard disk space issue
on this (its just a recent new disk installed, but had the problem
prior, so can't see fragmentation the issue)