Managing Data with Microsoft® Excel

Importing Data to Pivot Tables

If you've worked much with Excel's pivot tables, you're surely familiar with a list as a pivot table's data source. And you could use the data as shown in Figure 4.23 as a pivot table source, without any further manipulation.

Refer to Figure 4.15, which shows the Import Data window, which appears when you're through defining a query with Microsoft Query or with the Query Wizard. You'll notice in that window there's an option to create a pivot table report (the exact wording depends on the version of Excel that you're using). If you select this option, you see the final step in the Pivot Table Wizard instead of the external data range with its records and fields.

There's nothing special about this capability. You ...