J
jan.marien
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.aspx?scid=kb;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
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.aspx?scid=kb;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