Calculating Slow

Bob · Oct 10, 2003

Using an accounting application developed in
Excel.SumProduct,Named ranges and vlookup being used. No
macros.Problem is sluggish preformance with a 1000 or so
names in client list. Is there anything I can do to speed
up Calculation time?

Dave Peterson · Oct 10, 2003

I've never heard of excel.sumproduct, but you may want to take a look at these
two sites (Charles Williams and David McRitchie):

http://www.decisionmodels.com
http://www.mvps.org/dmcritchie/excel/slowresp.htm

Calculating Slow

Bob

Dave Peterson