Forum Discussion

Copper Contributor

Dec 12, 2018

Hardware usage of Excel 2016, supporting article or documention

Hi Team, I just want to confirm if Excel 2016 was designed to only use one-core even the machine's CPU has multi-core capability (let's say, a quad-core cpu). We noticed it on our office while ac...

excel

russel_enriquez

Copper Contributor

Dec 14, 2018

I have read some articles regarding the multi-core support for Excel, however, we already confirmed that this option was enabled (as default).

Maybe I just need to confirm:

1. How can I say or show to my bosses that Excel 2016 is already utilizing all/multi-cores? (that we might consider upgrading our hardware)

2. Or if not, are there any configuration recommended that I need to tick on our machines?

Thank you.

erol sinan zorlu

Iron Contributor

Dec 14, 2018

well the performance difference is great compared to excel 2003. If you have you can install a copy of it and calculate the same file with both of them. Or if you have a heavily formulated excel table you can turn of the multicore and calculate the same sheet while measuring the time with a chronometer and then activate it and recalculate it again.

russel_enriquez
Copper Contributor
Dec 14, 2018
Is there anything like a GUI-based way to see this with Windows? Like in task manager? I really appreciate you taking time to respond on this erol sinan zorlu
- erol sinan zorlu
  Iron Contributor
  Dec 14, 2018
  you need a very big excel file with lots of array formula in it.
  - russel_enriquez
    Copper Contributor
    Dec 14, 2018
    I mean, an interface where we can see that Excel is really using multi-cores instead of 25% only of the potential of the hardware? We can test it with your suggestion earlier, however, it might be more convincing if the performance data of Excel will be shown in graphs or numbers.