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