Pivot Table Data Crunching

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 ...