pivot tables: pivotselect with a very large table
 

I'm using the pivotselect function to do some custom formatting of a
pivot table.

The pivot table is generated via VBA scripting
the data set has approx 23000 rows with 9 columns, the pivot table
itself gets very large (to give an idea, it's in range B8 x K17000).


But as the pivot table can get very large, the pivot select doesn't
always work and there is no error thrown.
(http://support.microsoft.com/default...b;en-us;832293 )

Is there a way to calculate the fields that would be selected, so we
don't ran in to trouble with selection that's larger than the given
limit of 8,192 non-contiguous cells.

This is the code:
pvt.PivotSelect ("Employee[All;Total]"), xlDataAndLabel

With Selection.Interior
.ColorIndex = 15
.Pattern = xlSolid
.PatternColorIndex = xlAutomatic
End With