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)
|