How does this all perform in an xlsb file. This format is optimised for
speed. As eluded to, turning multi-calc off for non multi/dual core
processors will also speed things up

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
DTHIS
web: www.nickhodge.co.uk
blog: www.nickhodge.co.uk/blog/

FREE UK OFFICE USER GROUP MEETING, MS READING, 27th APRIL 2007
www.officeusergroup.co.uk

"Dana DeLouis" wrote in message
...
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