Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
file using pivot tables is too large | Excel Discussion (Misc queries) | |||
Pivot Table Data Adding contents of two pivot tables and param que | Excel Discussion (Misc queries) | |||
Sheet File To Large due to Pivot Tables? | Excel Programming | |||
Pivot Table Too Large? | Excel Discussion (Misc queries) | |||
Large Excel file size, no pivot tables | Excel Discussion (Misc queries) |