Lots of recommendations here from Charles Williams...
http://www.decisionmodels.com/memlimitsc.htm
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins / Excel Programming)


"wx4usa"
wrote in message I am using 15000 lines of data over 20 columns. Then Im using
sumproduct to run several reports within tabs in the same workbook. My
computer gets real slow then on save, I cannot because of the memory
error.

So, do I need a new computer. I have 1gb of ram now with an Intel
Celeron processor at 1.8Mhz.

Is it ram, processor speed, dual core or all 3 that would fix this?

Any recommendations?