Part VI: Working with PivotTables
This Part gives you the lowdown on PivotTables: sorting them, formatting them, hiding data, and more.
In This Part
Macro 62 Create a Backwards-Compatible PivotTable
Macro 63 Refresh All PivotTables Workbook
Macro 64 Create a PivotTable Inventory Summary
Macro 65 Make All PivotTables Use the Same Pivot Cache
Macro 66 Hide All Subtotals in a PivotTable
Macro 67 Adjust All Pivot Data Field Titles
Macro 68 Set All Data Items to Sum
Macro 69 Apply Number Formatting for All Data Items
Macro 70 Sort All Fields in Alphabetical Order
Macro 71 Apply Custom Sort to Data Items
Macro 72 Apply PivotTable Restrictions
Macro 73 Apply Pivot Field Restrictions
Macro 74 Automatically Delete Pivot Table Drill-Down Sheets
Macro 75 Print Pivot Table for Each Report Filter Item