Forum Discussion
Hardware usage of Excel 2016, supporting article or documention
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.
.png){kind=link}
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.
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
you need a very big excel file with lots of array formula in it.