The problem, as you have probably guessed, is lack of memory. If the other
file is very big, perhaps, Excel may be trying to hold both files in memory
to do the calculation, and it can't manage. If you have a number of
applications open at the same time (Outlook and Word, for example) you could
try without them running.

Jeff

"steph" wrote in message
...
I am having a problem saving data in an Excel 2002 workbook. I am unable
to
save the document with various SUMPRODUCT formulas which pull data from
another file on the same network. When I attempt to save the document, I
get
an error "Excel cannot complete this task with available resources.
Choose
less data or close other applications." I am forced to do a copy/paste
special/value exercise in order to save the data and then recreate the
formula each time I need it in subsequent months.

Can someone tell me if there is a trick to this?
--
Thanks so much!