Hello Everyone,
We have a pivot table that is being populated by an Excel worksheet
range. The range is filled by data retrieved by a stored proc.
Recently we exceeded the 65k row limit of Excel. I have been successful
in breaking up the feed to the worksheet into contiguos blocks of data -
each of 65k rows.

How do I combine all these blocks into single range for giving as input
to the Pivot table?
Does the Excel range have a 65 k row limit too?




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