spoolsv.exe consuming CPU when adding content to Excel worksheet from VBA
Posted on 2008-11-11
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