gbergsma
asked on
spoolsv.exe consuming CPU when adding content to Excel worksheet from VBA
Hi,
I have a VBAmacro under Excel. I am adding a lot of content to a number of worksheets and have found it to be very slow.
When I check Task Manager, there is a process "spoolsv.exe" that is consuming a stack of CPU time. If I kill it off, my macro runs like lightning.
Why would adding content to Excel worksheets cause a spoolsv.exe call anyway - isnt that related to printing?
Any suggestion as to how I can avoid spoolsv.exe from being called when I update the cells would be appreciated
Cheers
Greg
I have a VBAmacro under Excel. I am adding a lot of content to a number of worksheets and have found it to be very slow.
When I check Task Manager, there is a process "spoolsv.exe" that is consuming a stack of CPU time. If I kill it off, my macro runs like lightning.
Why would adding content to Excel worksheets cause a spoolsv.exe call anyway - isnt that related to printing?
Any suggestion as to how I can avoid spoolsv.exe from being called when I update the cells would be appreciated
Cheers
Greg
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
http://www.ozgrid.com/forum/showthread.php?t=73446
it might help you out.
im not sure if the same problem exist in excel 2007 (or 2002)