Chapter 8

Automating Common Reporting Tasks

In This Chapter

arrow Refreshing pivot tables with macros

arrow Leveraging macros to format pivot tables

arrow Applying pivot table restrictions

arrow Printing and exporting pivot data

arrow Resizing and aligning charts

arrow Exporting a set of disconnected charts

arrow 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.