Calculating Slow

[Bob]

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]

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