Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot Table Macro
I'm creating a pivot table in a macro and when it is done, I'm looking to
have the rows set to display detail=false. The rows contain employee names and may change from one pivot table to the next. When I do this manually with the recorder, I get the code: ActiveSheet.PivotTables("PivotTable3").PivotFields ("Employee").PivotItems( _ "Chappie").ShowDetail = False I thought I could enter wildcard * for Chappie, but that did not work. Is there a way I can set all of these to false without reading the name one by one? -- Thanx, I do appreciate it. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot Table external XLS file source change and GETPIVOTDATA refresh | Excel Discussion (Misc queries) | |||
Excel 2k Pivot Table refresh scenario | Excel Discussion (Misc queries) | |||
Pivot Table macro to set print area and print details of drill down data | Excel Discussion (Misc queries) | |||
Pivot table, dynamic data formula | Excel Discussion (Misc queries) | |||
Pivot Table Problems | Excel Discussion (Misc queries) |