Error in external named range

[Madiya]

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

 

[Madiya]

Pl help.

Regards,
Madiya

 

[Madiya]

Pl help.

Regards,
Madiya

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 -

 

[Dave Peterson]

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

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

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

 

[Madiya]

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

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

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

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]

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.

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

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

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

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 -