O'Reilly logo

Pivot Table Data Crunching by Michael Alexander, Bill Jelen

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

9. Using External Data Sources for Your Pivot Table

In this Chapter

Building a Pivot Table Using External Data Sources 155

Importing and Using External Data Without the PivotTable Wizard 161

Creating Dynamic Pivot Table Reporting Systems 161

Pivot Table Data Options 168

Building a Pivot Table Using External Data Sources

The general idea behind building your pivot table using an external data source is that you can create and use a pivot cache from a set of data that is not located in your Excel workbook. This means you can create a pivot table without one cell of data in your Excel workbook! Although there are many ways you can apply external data sources, one of the main benefits from this functionality is the ability to work around Excel’s ...

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