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