Chapter 8
Automating Common Reporting Tasks
In This Chapter
Refreshing pivot tables with macros
Leveraging macros to format pivot tables
Applying pivot table restrictions
Printing and exporting pivot data
Resizing and aligning charts
Exporting a set of disconnected charts
Printing all charts on a worksheet
For those of us tasked with building dashboards and reports, PivotTables and charts are a daily part of our work life. Few of us have had the inclination to automate any aspect of these reporting tools with macros. But some aspects of our work lend themselves to a bit of automation. In this chapter, you explore a handful of macros that can help you save time and gain efficiencies when working with pivot tables and charts.
Refreshing All Pivot Tables in a Workbook
It’s not uncommon ...
Get Excel Macros For Dummies 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.