K
kirk_stromberg
I've got several large datasets (couple hundred thousand rows), with
some custom VB functions and lookups, which feed a pivot table.
On a dual-core T60p thinkpad (WinXP, 3GB RAM), calculations can take a
while. The little message bar a the bottom of Excel shows that it
knows about the dual-cores while calculating.
However, sometimes calculations seems to be taking forever to
complete, so I'll pull up Task Manager to check the CPU utilization.
Why does Excel 2007 seem to stop at 50% utilization? I've got no
other primary applications running, so Excel will be pegged at 50% of
my CPU utilization, with a couple of percent for all of the other
system tasks running...and then 45-48% for the "System Idle Process".
How in the world do I make use of the 45-48% "idle" time and get Excel
to use more than 50%?
Seems like a waste - it's using both cores, but leaving way too much
head room. And all I can do is just sit around and wait for it to
finish?
I've tried manually setting the threads to more than 2 (like 4
calculation threads), but that doesn't seem to do it; I've also tried
setting Excel's process to be a higher-than-normal priority in task
manager.
Any ideas out there?
Thanks!
Kirk
some custom VB functions and lookups, which feed a pivot table.
On a dual-core T60p thinkpad (WinXP, 3GB RAM), calculations can take a
while. The little message bar a the bottom of Excel shows that it
knows about the dual-cores while calculating.
However, sometimes calculations seems to be taking forever to
complete, so I'll pull up Task Manager to check the CPU utilization.
Why does Excel 2007 seem to stop at 50% utilization? I've got no
other primary applications running, so Excel will be pegged at 50% of
my CPU utilization, with a couple of percent for all of the other
system tasks running...and then 45-48% for the "System Idle Process".
How in the world do I make use of the 45-48% "idle" time and get Excel
to use more than 50%?
Seems like a waste - it's using both cores, but leaving way too much
head room. And all I can do is just sit around and wait for it to
finish?
I've tried manually setting the threads to more than 2 (like 4
calculation threads), but that doesn't seem to do it; I've also tried
setting Excel's process to be a higher-than-normal priority in task
manager.
Any ideas out there?
Thanks!
Kirk