13. Using VBA to Create Pivot Tables

In This Chapter

Enabling VBA in Your Copy of Excel

Using a File Format That Enables Macros

Visual Basic Editor

Visual Basic Tools

The Macro Recorder

Understanding Object-Oriented Code

Learning Tricks of the Trade

Understanding Versions

Building a Pivot Table in Excel VBA

Dealing with Limitations of Pivot Tables

Pivot Table 201: Creating a Report Showing Revenue by Category

Calculating with a Pivot Table

Using Advanced Pivot Table Techniques

Using the Data Model in Excel 2016

Version 5 of Excel introduced a powerful new macro language called Visual Basic for Applications (VBA). Every copy of Excel shipped since 1993 has had a copy of the powerful VBA language hiding behind the worksheets. VBA enables you ...

Get Excel® 2016 Pivot Table Data Crunching now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial