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?