| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Looking to remove pivot fields from pivot table via macro
I have four pivot views, D Rank, S Rank, B Rank and O Rank. I know
how to add an items as illustrated below below, however removing it errors when it's actually not there...how do I avoid this is my question? ActiveCell.FormulaR1C1 = "Data Completeness Rank" ' if the Pivot field is not showing I error out just below ActiveSheet.PivotTables("PivotTable1").PivotFields ("S Rank").Orientation _ = xlHidden ActiveSheet.PivotTables("PivotTable1").PivotFields ("B Rank"). _ Orientation = xlHidden ActiveSheet.PivotTables("PivotTable1").PivotFields ("O Rank"). _ Orientation = xlHidden ActiveSheet.PivotTables("PivotTable1").AddDataFiel d ActiveSheet.PivotTables( _ "PivotTable1").PivotFields("DC Rank"), "Sum of DC Rank", xlSum |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Problem inserting calculated pivot fields into Pivot Table (2007) | Excel Discussion (Misc queries) | |||
| Macro on filtering pivot table (pivot fields) = debug | Excel Programming | |||
| Remove grouped items and fields from pivot table | Excel Discussion (Misc queries) | |||
| Pivot Table Macro not inserting all data fields | Excel Discussion (Misc queries) | |||
| How to remove Drop Page Fields Here from Pivot Table | Excel Discussion (Misc queries) | |||
Threaded Mode
