Excel 2007 PivotTables Recipes: A Problem-Solution Approach

CHAPTER 9Printing and ExtractingPivot Table Data

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.

After you create a pivot table, you may want to extract some of the summarized data for use in other parts of the workbook. The GetPivotData worksheet function can be used for ...