M
Mercedes Clements
I have an Excel Workbook that has several simple view and
print macros that are suddenly (in the last week) running
very slowly. Previously there was no delay when using
the button, now it takes a minute plus to change views or
generate the print job
By simple - sample code
ActiveWorkbook.CustomViews("BegBal").Show
The views can be called manually with no problems, and I
can manually move around in the Workbook with no problems
(switching tabs, triggering print jobs, switching views
by name)
This problem has effected all copies of the Workbook in
Excel 2000, 2002, and 2003 (on Windows 2000/XP) including
the original master template with no data. I have copied
the file to a local hard drive to rule out network issues
and attempted it on several computers. Excel is not
using significant resources during the process.
I have turned off automatic calculations and minimized
iterations as troubleshooting steps. These changes did
not help.
Once the macro has run once, it will run quickly again as
long as you don't close the workbook (everytime you open
the workbook the macros start out running slowly).
The only common thread I can identify is that all the
machines were patched last week with the latest security
updates from Microsoft. I am going to unpatch a machine
and try that next.
Any thoughts?
Thanks,
Merc
print macros that are suddenly (in the last week) running
very slowly. Previously there was no delay when using
the button, now it takes a minute plus to change views or
generate the print job
By simple - sample code
ActiveWorkbook.CustomViews("BegBal").Show
The views can be called manually with no problems, and I
can manually move around in the Workbook with no problems
(switching tabs, triggering print jobs, switching views
by name)
This problem has effected all copies of the Workbook in
Excel 2000, 2002, and 2003 (on Windows 2000/XP) including
the original master template with no data. I have copied
the file to a local hard drive to rule out network issues
and attempted it on several computers. Excel is not
using significant resources during the process.
I have turned off automatic calculations and minimized
iterations as troubleshooting steps. These changes did
not help.
Once the macro has run once, it will run quickly again as
long as you don't close the workbook (everytime you open
the workbook the macros start out running slowly).
The only common thread I can identify is that all the
machines were patched last week with the latest security
updates from Microsoft. I am going to unpatch a machine
and try that next.
Any thoughts?
Thanks,
Merc