I have an excel workbook that do a monte carlo simulation where the recalculation take much too time for the purpose. In an attempt to speed things up I have made radical redesigns and the recalculation time has improved some but not enough.
I really need to trigger multithreaded recalculations: for that I have removed the need for VBA, I have replaced a data table with individual calculations but it still takes the same time to recalculate with one, two or four cores activated.
To figure out how to make a workbook that do multithreaded calculations I now have tried go to the other way: Make as simple a version of the structure I am trying to build as possible that ought to be an ideal candidate for multiple threaded calculations: The simple coin toss model: first cell flips a coin and add 1 if it is head, -1 if tails. Next in the row do the same and adds the value of the first cell aso for five cells. The first cell then add the value of the last cell for 10000 iterations. That is not itself a good candidate for multithreading but I do the same calculation in 1000 rows without any reference between the rows and it ought to be obvious for Excel that each row could be calculated in its own thread, no? But it doesn´t. What am I not seeing here?
Link to workbook: https://dl.dropboxusercontent.com/u/1624676/testbed.xlsm It has a macro that only disable screen update while doing the recalculation. Opening the workbook as .xls or .xlsm file makes no difference...
I really need to trigger multithreaded recalculations: for that I have removed the need for VBA, I have replaced a data table with individual calculations but it still takes the same time to recalculate with one, two or four cores activated.
To figure out how to make a workbook that do multithreaded calculations I now have tried go to the other way: Make as simple a version of the structure I am trying to build as possible that ought to be an ideal candidate for multiple threaded calculations: The simple coin toss model: first cell flips a coin and add 1 if it is head, -1 if tails. Next in the row do the same and adds the value of the first cell aso for five cells. The first cell then add the value of the last cell for 10000 iterations. That is not itself a good candidate for multithreading but I do the same calculation in 1000 rows without any reference between the rows and it ought to be obvious for Excel that each row could be calculated in its own thread, no? But it doesn´t. What am I not seeing here?
Link to workbook: https://dl.dropboxusercontent.com/u/1624676/testbed.xlsm It has a macro that only disable screen update while doing the recalculation. Opening the workbook as .xls or .xlsm file makes no difference...
