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!