View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.misc
dlw dlw is offline
external usenet poster
 
Posts: 510
Default XL2007 vs XL203 speed

On the same hardware, newer versions are ALWAYS SLOWER than older versions.
Either wait for a service pack that may or may not speed it up, or get a
better computer.

"Bernard Liengme" wrote:

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