PIVOT TABLES IN VBA
 

Question -

Is it possible to create a pivot table on a range or array larger
than 65,000 rows ?
Can it be done in VB off the worksheet?
Once it has been created, is it possible to do a split page as is
possible in Pivot tables?

I'm working with a very large dataset and this might be a good
approach.
The reason I'm not looking to do it on a worksheet (in addition to the
fact that its too big) is that many of the split pages will have no
values and I only need those that do.

Effectively the P/T would have 2 page drivers, about 5 row, 1 column,
and the sum.

Thanks in advance

PIVOT TABLES IN VBA
 

Must be done in a worksheet in Excel.

I suppose you can do it, because there is an option in the setup wizar
to use "multiple consolidation ranges". You don't get as much layou
flexibility though. Pages are possible. The final table cannot excee
certain limitations, as with any PT.

I would link to an MS Access table in this scenario

--
Message posted from http://www.ExcelForum.com

PIVOT TABLES IN VBA
 

That would be nice, but we don't have Access

BrianB wrote in message ...
Must be done in a worksheet in Excel.

I suppose you can do it, because there is an option in the setup wizard
to use "multiple consolidation ranges". You don't get as much layout
flexibility though. Pages are possible. The final table cannot exceed
certain limitations, as with any PT.

I would link to an MS Access table in this scenario.


---
Message posted from http://www.ExcelForum.com/