"cottage6" wrote in message
...
Macros I've created in Excel 2000 SP3 have always executed very rapidly,
but
within the last week that's changed and any macro in any file now executes
slowly. I also have Excel 2002 SP3 installed on the same drive (C), and
running the same macros in the same files in 2002 is much faster. I have
been
working with a very large file that uses cubes created in MS SQL that are
then used to create pivot tables. This file has been edited and saved in
both Excel 2000 and 2002 as I need to make sure it's usable in both
versions.
I'm not sure if this is causing the problem or not, but any ideas short of
re-installing Excel 2000 would be great. I have Windows 2000. TIA!

Waht does your macros do? Do they call SQL Server? Does your macros run
faster on some other machine? Since you are working with very large files,
how much free diskspace do you have? Have you defrag'ed your hard disk?

/Fredrik