Rowland Hamilton
Active Member
- Joined
- Nov 13, 2009
- Messages
- 250
Folks:
How do you write a macro to expand all pivot table fields in Excel 2010.
Hit + buttons on all like when recorded for just this one:
Thanks, Rowland
How do you write a macro to expand all pivot table fields in Excel 2010.
Hit + buttons on all like when recorded for just this one:
Code:
ActiveSheet.PivotTables("PivotTable2").PivotFields( _
"Cost Center").PivotItems("77194").ShowDetail = True
Thanks, Rowland