Thanks for your insight Jim.
I have takent he second option -w eher I split the recordset into
non-contigious blocks of data, each of which can be a max 65 k rows.
However I'm not having any luck in combinin these ranges into one range
that can be given as Source Data for the Pivot. I tried range operations
like Union- but that is not giving me what I want.
So my question to you is -how can I setup the source data of the Pivot
to point to non-contiguous ranges in my worksheet



*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!