When apply a apply a resource heavy formula to a table with autofill, excel does not use more than 30% CPU. The load is split between 4 cores with 2 logical processors each. CPU load jumps up and down for all 8 processing units. It looks like this when running:
Settings is set to multi threading enabled and gfx disabled. I have also tried disabling multi threading, with no change in cpu performance.
The formula includes arrays (sumproduct) and will run for 5-6 hours. I would like that to get down to 2 hours.
Any idea of why I'm experiencing this poor cpu performance with excel?