Prev: forgot to attach doc sent via email, original's not saved. can it.
Next: CountIf 2 columns
From: BJ&theBear on 26 Apr 2010 09:46
I have just inserted a series of 8 calculated fields using sumproduct
into a spreadsheet which references a closed workbook and have now
been given the error - "Excel cannot complete this task with
available resources. Choose less data or close other applications"

Any bright ideas on how to make additional resources available as
there are no other applications open.


Any help would be appreciated

BJthebear
From: Jim Thomlinson on 26 Apr 2010 10:33
Here is a link to info on memory, speed and calculation.

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

Wtihout seeing your formulas it is hard to comment further.
--
HTH...

Jim Thomlinson


"BJ&theBear" wrote:

> I have just inserted a series of 8 calculated fields using sumproduct
> into a spreadsheet which references a closed workbook and have now
> been given the error - "Excel cannot complete this task with
> available resources. Choose less data or close other applications"
>
> Any bright ideas on how to make additional resources available as
> there are no other applications open.
>
>
> Any help would be appreciated
>
> BJthebear
> .
>
 | 
Pages: 1
Prev: forgot to attach doc sent via email, original's not saved. can it.
Next: CountIf 2 columns