O'Reilly logo

Programming Excel with VBA and .NET by Steve Saunders, Jeff Webb

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Program Pivot Tables

You can navigate to pivot table objects from the Workbook, Chart, Worksheet, or Range objects as shown in Figure 13-18.

Navigating the pivot table objects

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.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required