Office 2000 Excel Macro runs very slow in 2003, why?

[Guest]

Hi

I have a user who had a macro that ran fine under Office 2000. Following a
recent upgrade to Office 2003 the macro's are running really really slowly.
He assures me that he has made no changes to the files.

We have also tried running them from a different location, (files are
usually on a shared network drive) but even running them on the local mchaine
takes ages.

Any ideas of a setting that needs tweaking or a an update required for the
macro? Since the macro is a fairly big one the user is not too keen to build
it from scratch again. (This was my initial suggestion)

Thanks for any help,

Mike

 

[notawahoo]

I write large macros that are used by dozens of different users. The
single thing that makes the most difference in how quickly the macros
execute is the default printer that each user has assigned. The more
wonderful bells-and-whistles the printer, the slower the macro will go.
I have my own default printer assigned to a plain vanilla HP Deskjet
that we don't even have (just loaded the driver). When I want to
actually print something (rarely), then I change the default printer.

Try changing your printer assignment by choosing File / Print, and then
choose a simple printer. You can then click CLOSE to get out of the
printer assignment window so you don't actually have to print anything
(like your macro workbook). Then execute the macro as you usually
would.

Hope that helps,

Nancy