15. Dr. Jekyll and Mr. GetPivotData
In This Chapter
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 ...
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.