Printing and Extracting Pivot Table Data

Abstract

One of the strengths of pivot tables is the capability to change the layout and analyze data from different perspectives. Sometimes, though, you want a static picture from the pivot table and need to print the data. For the most part, pivot tables print the same as other data on a worksheet, but you can apply a few special settings to a pivot table. Some printing issues, such as printing a copy of the pivot table for each item in the Report Filter field, can be solved by programming, and examples are given in Chapter 11.