Multithread Data-Table Calculations

[eisenpony]

Data-table calculations seem to be the perfect target for multithreaded calculations. In my tests though, Excel caps out at 12.5% CPU on my 8 core machine. Am I doing something wrong? Are data-tables really not MTC compatible? Any technical reason they shouldn't be?

 

[pgc01]

Hi
Welcome to the board

I'd say you have no luck.

The last time I saw information about it MS says that data tables are not calculated using multithreading.

See this article about Excel 2010 Performance and Limit Improvements. Look for data tables in the Multithreaded Calculation section (that refers still to xl2007):

https://msdn.microsoft.com/en-us/library/office/ff700514(v=office.14).aspx

 

[ruiseixas]

Hi
Welcome to the board

I'd say you have no luck.

The last time I saw information about it MS says that data tables are not calculated using multithreading.

See this article about Excel 2010 Performance and Limit Improvements. Look for data tables in the Multithreaded Calculation section (that refers still to xl2007):

https://msdn.microsoft.com/en-us/library/office/ff700514(v=office.14).aspx

Hi,

I have a PC with 6 cores, and I did a little experience with data tables.

My original data-table was 100 rows by 21 columns. With or without multi-thread enabled in advanced options it took the same time:

- 6m 36s

Then I split the data table, each one with the size 100 rows by 7 columns, 1/3 of the original size, each one in its own calculation sheet. With or without multi-thread enabled in advanced options it took the same time:

- 17m 6s

So the result, when the data tables are split and separately calculated, is several times as much as the number of splits. So, 100*21 takes 3 times less than 3*(100*7) despite representing the same 2100 cells!

My only explanation is that excel uses multi-thread in data tables (not split).

Regards,
Rui