Excel® 2016 Pivot Table Data Crunching

15. Dr. Jekyll and Mr. GetPivotData

In This Chapter

Avoiding the Evil GetPivotData Problem

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