Macro slow after 2003 upgrade
Have you found a solution to this problem? I'm having the same problem and
have been able to speed it up a bit by turning page breaks off (Tools |
Options | View tab | uncheck Page Breaks). It was off in 2002 and on in 2003.
That didn't completely solve the problem, and I'm still searching.
"Nate Moeller" wrote:
We recently updated from Office XP to Office 2003. With the upgrade, our
Excel macro performance has degraded considerably. Macro time has increased
as much as 10x in some cases. The hardware has not changed and no other
programs have been installed. I have checked the terminal server and PC we
run them on and they are running at the same levels of performance as before
the upgrade. I assumed it is some setting in Excel that has changed but I
can find no information if one exists. Any help would be sincerely
appreciated.
Thanks,
--
Nate Moeller
|