Excel® Programming: Your visual blueprint™ for creating interactive spreadsheets

Chapter 16. Working with PivotTables

Create a PivotTable

PivotTables help you answer questions about your data. A PivotTable shows how data is distributed across categories. For example, you can use a PivotTable to see how different products sell by region or by quarter. You base PivotTables on lists. You can use a worksheet list or you can connect to a list from another data source, such as Access.

A PivotCache object represents the memory cache for a PivotTable report. You must create a PivotCache object for your PivotTable. Use the PivotCaches.Create method. The PivotCaches.Create method has three parameters: SourceType, SourceData, and Version. Use an XlPivotTableSourceType to specify the SourceType. Use xlconsolidation if the source is a consolidation, ...