Just throwing this out. I would be curious to learn if setting it to 1,
instead of Automatic, makes a difference...
Application.MultiThreadedCalculation.ThreadCount = 1
'Solver here...
Reset back to default...
Application.MultiThreadedCalculation.ThreadMode = xlThreadModeAutomatic
--
Dana DeLouis
Windows XP & Office 2007
"Bernard Liengme" wrote in message
...
Just to add to the discuss:
I have a Solver model (engineering problem called the four-bar crank) with
2 variables and 73 constraints of the form a=0. In XL2003 this takes about
5 seconds; in XL2007 it takes 25 sec. A 1:5 ratio the wrong way around -
one expects newer versions to be faster!
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email