15. Dr. Jekyll and Mr. GetPivotData

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:

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

Image There is no easy way to build an asymmetric pivot table. Using named sets is one way, but they are available only ...

Get Excel® 2016 Pivot Table Data Crunching now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.