Microsoft Excel Pivot Table Data Crunching (Office 2021 and Microsoft 365)

CHAPTER 15. Dr. Jekyll and Mr. GetPivotData

In this chapter, you will:

• Avoid the aggravating GetPivotData problem

• Use GetPivotData to solve pivot table annoyances

This chapter shows you a technique that solves many annoying pivot table problems. If you have been using pivot tables for a while, you might have run into the following problems:

• Formatting tends to be destroyed when you refresh a pivot table. Numeric formats are lost. Column widths go away.

• There is no easy way to build an asymmetric pivot table. Using named sets is one way, but they are available only in a pivot table model, not in a regular pivot cache pivot table.

• Excel cannot remember a template. If you frequently have to re-create a pivot table, you must redo the groupings, ...