Need help saving file with SUMPRODUCT formula

[steph]

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?

 

[Jeff Standen]

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]

Jeff, that was my fear .

The document I am pulling from can be very large (~50 - 100 MG) but it
doesn'st start out that large. I will try to create the document with the
SUMPRODUCTs at the beginning of my process--before additional
worksheets/pivot tables are added to the source document--instead of at the
end and see if that helps at all. I'll also try to remember to close down
Outlook and IE when doing this to see if that is any help.

Thanks for the suggestion.

 

[Jim Thomlinson]

Physical memory is not the issue. Excel has inherant limits. Here is a
resource to check out...

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