Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Remove all column and row fields from a pivot table
I know how to add a field (see below) to a pivot table, but from a
state where I don't know which columns and rows are added to the pivot table, how can I "reset" the pivot table so I can add only the fields I'm interested in? Sheet1.PivotTables("PivotTable8").AddFields RowFields:="Customer", _ ColumnFields:="CloseQuarter" With Sheet22.PivotTables("PivotTable8").PivotFields("Sa les") .Orientation = xlDataField .Function = xlSum .Position = 1 End With |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
remove add pivot table fields | Excel Programming | |||
Looking to remove pivot fields from pivot table via macro | Excel Programming | |||
Remove grouped items and fields from pivot table | Excel Discussion (Misc queries) | |||
Pivot table: showing COLUMN summaries for some, not all, COLUMN fields. | Excel Programming | |||
How to remove Drop Page Fields Here from Pivot Table | Excel Discussion (Misc queries) |