Out of Memory Error

[Jimmy D]

I have a large amount of data in one excel file and another file with Dsums
looking in to it to produce a readable document. Every time I open the file I
have an out of memory message and errors on many summs. However if I open the
source file and then close it again all the errors dissapear. This has only
just started to occur with my system and on previous occasions using this
file everything worked fine.
I do not think I have too much data as I have worked with larger files with
this same program. I am using excel 97.
Has anyone experienced similar problems?

 

[Jimmy D]

Found info on surfing details are in the following
apparently excel sets its own limits on memory and it is different for many
of the year models. Suggested reading is:

http://www.decisionmodels.com/memlimitsc.htm