I have created several external named range, for e.g.
='C:\Documents and Settings\madiya\Desktop\[RUIM Master
File.xls]Reciept Data'!$E$1:$E$20000

I intend to use it in sumproduct formulas but on testing I got error
as below.

Excel cannot complete this task with available resources. Choose less
data or close other applications. <OK button

I used the same in counta formula. While saving the file above error
came up.

Need help to resolve the issue.

Regards,
Madiya

Pl help.

Regards,
Madiya

On Aug 21, 7:40 pm, Madiya wrote:
I have created several external named range, for e.g.
='C:\Documents and Settings\madiya\Desktop\[RUIM Master
File.xls]Reciept Data'!$E$1:$E$20000

I intend to use it in sumproduct formulas but on testing I got error
as below.

Excel cannot complete this task with available resources. Choose less
data or close other applications. <OK button

I used the same in counta formula. While saving the file above error
came up.

Need help to resolve the issue.

Regards,
Madiya

On Aug 22, 12:23 pm, Madiya wrote:
Pl help.

Regards,
Madiya

On Aug 21, 7:40 pm, Madiya wrote:



I have created several external named range, for e.g.
='C:\Documents and Settings\madiya\Desktop\[RUIM Master
File.xls]Reciept Data'!$E$1:$E$20000

I intend to use it in sumproduct formulas but on testing I got error
as below.

Excel cannot complete this task with available resources. Choose less
data or close other applications. <OK button

I used the same in counta formula. While saving the file above error
came up.

Need help to resolve the issue.

Regards,
Madiya- Hide quoted text -

- Show quoted text -

Can you reduce the range--not use 20000 rows?

If not, maybe you can use multiple formulas and multiple ranges (5000 rows
each?).

Madiya wrote:

I have created several external named range, for e.g.
='C:\Documents and Settings\madiya\Desktop\[RUIM Master
File.xls]Reciept Data'!$E$1:$E$20000

I intend to use it in sumproduct formulas but on testing I got error
as below.

Excel cannot complete this task with available resources. Choose less
data or close other applications. <OK button

I used the same in counta formula. While saving the file above error
came up.

Need help to resolve the issue.

Regards,
Madiya

--

Dave Peterson

Hi Dave,
I have created 4 different range names of 5000 cells each.
But still I am getting the same error.
Any thoughts?

Regards,
Madiya


On Aug 22, 6:47 pm, Dave Peterson wrote:
Can you reduce the range--not use 20000 rows?

If not, maybe you can use multiple formulas and multiple ranges (5000 rows
each?).





Madiya wrote:

I have created several external named range, for e.g.
='C:\Documents and Settings\madiya\Desktop\[RUIM Master
File.xls]Reciept Data'!$E$1:$E$20000

I intend to use it in sumproduct formulas but on testing I got error
as below.

Excel cannot complete this task with available resources. Choose less
data or close other applications. <OK button

I used the same in counta formula. While saving the file above error
came up.

Need help to resolve the issue.

Regards,
Madiya

--

Dave Peterson- Hide quoted text -

- Show quoted text -

Make 8 of 2500 rows.
or
16 of 1250
or...
until it works.

You may want to try opening the other workbook to see if that makes it easier
for excel to calculate.

Madiya wrote:

Hi Dave,
I have created 4 different range names of 5000 cells each.
But still I am getting the same error.
Any thoughts?

Regards,
Madiya

On Aug 22, 6:47 pm, Dave Peterson wrote:
Can you reduce the range--not use 20000 rows?

If not, maybe you can use multiple formulas and multiple ranges (5000 rows
each?).





Madiya wrote:

I have created several external named range, for e.g.
='C:\Documents and Settings\madiya\Desktop\[RUIM Master
File.xls]Reciept Data'!$E$1:$E$20000

I intend to use it in sumproduct formulas but on testing I got error
as below.

Excel cannot complete this task with available resources. Choose less
data or close other applications. <OK button

I used the same in counta formula. While saving the file above error
came up.

Need help to resolve the issue.

Regards,
Madiya

--

Dave Peterson- Hide quoted text -

- Show quoted text -

--

Dave Peterson