Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pivottable
Hi
I want to hide all item in a pivotfield , but not the first one. Now I use this code, but it takes a lot of time to loop (4000 items). Can I do it in a other way, to do it faster? With ActiveSheet.PivotTables("PivotTable1").PivotFields ("PRODNO") For I = 2 To .PivotItems.Count .PivotItems(I).Visible = False Next I End With Regards // Lasse |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Creating a PivotTable w/o selecting data in an existing PivotTable | Excel Discussion (Misc queries) | |||
Pivottable | Excel Discussion (Misc queries) | |||
How does one get the PivotTable report info that feeds another PivotTable report? | Excel Programming | |||
PivotTable - PivotTable Field name is not valid - error! | Excel Programming | |||
Creating a PivotTable Report from an Another PivotTable Report | Excel Programming |