Multi threaded calculation (multi CPU) - impact on calculation spe

[Pascal]

I'm using huge calculation sheets for specific Engineering applications where
the iteration calculation are very low (<5.000 iteration per hour).
I have a labotp with 2 CPU, and Excel 2007 (where you can define wether you
use 1 or 2 CPU for the calculation.
Whatever the nr CPU is (1 or 2), the Excel calculation speed remains
unchanged.
I were thinking to reach higher speed with 2 CPU instead of 1 CPU.
Does somebody has the same experience or idea to be abble to use more then 1
CPU?
I'm thinking to buy a computer with 8 CPU for other time consuming
applications (not Excel), will Excell be improved by this extra nr of CPU?

 

[Charles Williams]

Hi Pascal,

If you are using circular references and Excel's iterative calculation
methods then Excel 2007 does not use multithreaded calculation on the cells
in being calculated in the circular chains.

If you are not using circular references but controlling the iteration
through VBA then the VBA part of the process will not use multithreaded
calculation but any Excel calculation initiated from VBA will use
multithreaded calculation ( except for Range.Calculate and
Range.CalculateRowMajorOrder) .

If you are using Excel's iterative calculation method then make sure all the
cells in the circular chains are on a single worksheet and that you have
minimised the number of calculations and cell references Excel has to
perform in each iteration.

Charles
__________________________________________________
The Excel Calculation Site
http://www.decisionmodels.com