PIVOT TABLES IN VBA

M

Marston

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
 
B

BrianB

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
 
Top