14. 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 these problems:
• Formatting tends to be destroyed when you refresh your pivot table. Numeric formats are lost. Column widths go away.
• There is no way to build an asymmetric pivot table. Named Sets offer hope, but only for those using OLAP data or those who have the time to convert their Excel data to the PowerPivot window.
• Excel cannot remember a template. If you frequently have to re-create a pivot table, you must redo the groupings, ...
Get Pivot Table Data Crunching: Microsoft® Excel® 2010 now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
