I know that Excel uses multithreading for calculation, but I could not find details about multithreading for matrix and array formulas, such as
REDUCE and the like.
I have two questions:
Does Excel calculate different array formulas simultaneously? (e.g. several columns, each of which is a separate array formula with many rows)
Does Excel ever use multiple threads to calculate a single array or matrix formula?
My experience suggests that the answers are:
based on the fact that I can achieve close to 100% CPU utilization with about 10 independent large array formulas on a worksheet, but I haven't been able to go over 15% utilization with a single formula or several formulas dependent on each other.
The official documentation (https://docs.microsoft.com/en-us/office/client-developer/excel/multithreading-and-memory-management) is silent on this topic, is there any other source of information or some way to verify how multithreading works with matrix and array formulas?