View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.misc
Harlan Grove[_2_] Harlan Grove[_2_] is offline
external usenet poster
 
Posts: 1,231
Default XL2007 vs XL203 speed

"Dana DeLouis" wrote...
Just throwing this out. I would be curious to learn if setting it
to 1, instead of Automatic, makes a difference...

Application.MultiThreadedCalculation.ThreadCoun t = 1

'Solver here...

Reset back to default...

....

Begs the question why Solver would go fubar if run multithreaded. One
would have thought it was an obvious candidate for multithreading
since it could calculate objective functions and support given
constraints at the same time, not to mention displaying iteration
results.