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!