Forum Discussion
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 accessing a spreadsheets with a large bulk of calculations in it, where Excel is only maximizing one core (25% of CPU's capability), thus, affecting Excel
I'm was also able to read this article, however, from a different source: https://askleo.com/why_wont_my_program_use_more_than_25_of_the_cpu/
I'll be requesting for a supporting documentation, or if someone can enlighten me with this, that would be greatly appreciated.
Regards,
Russel
Since Excel 2007 Excel has multi core support. This option is in Options-->Advanced tab in the Formulas area. There is a checkbox to enable Excel to use all the cores available. And by default this option is selected. You need to check it if Excel uses only single core during calculations in your computer.
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.
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.
.png){kind=link}