Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
slow macro execution
Hi
I am running a macro that creates a series of workbooks... and does major changes to these workbooks (ex: change Name definitions, update Query tables, etc.) The problem is that it runs very slow although the Excel process is only taking 1-3% of available processor time... Normally if Excel would take more the macro should run faster, right? How can I force Excel to use more of the processor? Thanks |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
slow macro execution
See this Site's Vasile
Charles Williams http://www.decisionmodels.com/optspeedd.htm#OpSave Some tips on overcoming slow response (David McRitchie) http://www.mvps.org/dmcritchie/excel/slowresp.htm -- Regards Ron de Bruin (Win XP Pro SP-1 XL2002 SP-2) www.rondebruin.nl "Vasile Dumitrescu" wrote in message ... Hi I am running a macro that creates a series of workbooks... and does major changes to these workbooks (ex: change Name definitions, update Query tables, etc.) The problem is that it runs very slow although the Excel process is only taking 1-3% of available processor time... Normally if Excel would take more the macro should run faster, right? How can I force Excel to use more of the processor? Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do I turn the screen off during macro execution | Excel Worksheet Functions | |||
Macro Execution | Excel Discussion (Misc queries) | |||
Macro Execution, Part Duo | Excel Discussion (Misc queries) | |||
Naming a range during macro execution | Excel Discussion (Misc queries) | |||
Password required before Macro execution | Excel Discussion (Misc queries) |