4 ms·
Excel uses multiple cores for calculations. You can configure how many to prevent it sucking up the entire CPU for long calculations. It's a pretty easily para
by ddeck 10y ago
Excel uses multiple cores for calculations. You can configure how many to prevent it sucking up the entire CPU for long calculations.
It's a pretty easily parallelizable problem since the sheet is just a dependency tree with the cells as nodes.
The build-in functions (e.g. probability distributions etc.) could also be multi-threaded, although I'm not sure if they are. Our external API called from cells was written in C++ and already multi-threaded.
More info here:
https://msdn.microsoft.com/en-us/library/office/bb687899.aspx https://msdn.microsoft.com/en-us/library/office/bb687899.asp...