Hi!!

Sorry to bother you again... this no. of records really causing a problem,
when I set 65000 as a upper limit for my array in formulas, XL is not
allowing me to save the data and giving following warning

"Excel Can not complete this task with available resource, chose less data
or close other application"

"Unable to save external link value"

Is this the memory issue?? I am using 2 GHz Intel Dual processor with 2 GB
RAM.

Can you please advise on this?

Cheers!
-- Milind




"Pete_UK" wrote:

You're welcome - thanks for feeding back.

Pete

On Sep 4, 1:48 pm, Milind Keer
wrote:
Thanks again pete!! I will certainly try to implement your suggestion.

Well!! we get this huge data file on monthly basis and currently record
contains 55000 rows which may increase in future. Hence on the safer side i
kept no. of rows 65000 which is the upper limit of XL.

I guess accurate upper limit is 65536 rows but for an array u can use 65535.