View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Ron de Bruin Ron de Bruin is offline
external usenet poster
 
Posts: 11,123
Default 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