You use PivotTables to summarize complex data. This chapter examined various techniques that you can use to create PivotTables from a data source such as an Excel Table using VBA.
The chapter covered setting up PivotCaches and showed how they relate to PivotTables. You can add fields to PivotTables as row, column, or data fields. You can calculate fields from other fields, and items in fields. You can group items. You might do this to summarize dates by years and months, for example. You can hide items, so you see only the data required.
You can link a PivotChart to a PivotTable so changes in either are synchronized. A PivotLayout object connects them.
Using ADO, you can link your PivotTables to external data sources.
Was this article helpful?
Get Inspired By The Most Popular Bloggers Online! If You Want To Skyrocket Your Success With Business And Improve Your Overall Life You Need To Have A Look At The Accidental Blogging Millionaires! Business can be a fight, particularly when you’re trying to establish one online and like all fights, to succeed you must find the winning techniques and apply them.