Chapter 8
Automating Common Reporting Tasks
IN THIS CHAPTER
Refreshing all PivotTables
Creating a PivotTable inventory summary or a set of disconnected charts
Adjusting all pivot data field titles
Setting all data items to sums
Setting the number format or custom sort for all data items
Sorting all fields in alphabetical order
Applying PivotTable and pivot field restrictions
Automatically deleting PivotTable drilldown sheets
Printing PivotTable for each report filter item or for all charts
Creating new workbook for each report filter item
Resizing or aligning charts
If you’re tasked ...
Get Excel Macros For Dummies, 3rd Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
