Microsoft Office Tutorials and References
In Depth Information
Create a PivotTable from External Data
Create a PivotTable from
External Data (continued)
The Choose Data Source dialog box and the
various Query Wizard dialog boxes are not part
of Excel. Instead, they are components of a
program called Microsoft Query. You can use
this program to work with external data.
This section assumes that you have already
defined the appropriate data source, and that
you do not want to work with Microsoft
Query directly. Note, too, that steps 14 and 15
skip over the Query Wizard dialog boxes that
enable you to filter and sort the external data,
because this is not usually pertinent for a
The other assumption made in this section is
that you do not want the external data to be
imported to Excel. Rather, in this section, the
external data resides only in the new
PivotTable’s pivot cache; you do not see the
actual data in your workbook. However, you
can still easily refresh and rebuild your
PivotTable, just like you can with a report
based on a local range or list.
The Query Wizard - Filter
Data dialog box appears.
$ Click Next.
The Query Wizard - Sort
Order dialog box
% Click Next.
The Query Wizard -
Finish dialog box
^ Select the Return Data to
Microsoft Excel option.
& Click Finish.