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
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.
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.
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.