You can navigate to pivot table objects from the
Range objects as shown in Figure 13-18.
Figure 13-18. Navigating the pivot table objects
Although pivot tables expose a full set of objects, the most common set of programming tasks deal with this narrow set of problems:
Create a pivot table.
Refresh a pivot table automatically when the source data changes.
Build a pivot table from an external data source.
The following sections explain how to program those tasks.