Microsoft Office Tutorials and References
In Depth Information
from an external data connection that uses multiple tables. I provide an example of us-
ing the Data Model later in this chapter.
If you're creating a pivot table from data in a worksheet, it's a good idea to first create a
table for the range (by choosing Insert ⇒ Tables ⇒ Table). Then, if you expand the table by
adding new rows of data, Excel will refresh the pivot table without you needing to
manually indicate the new data range.
Specifying the location for the pivot table
Use the bottom section of the Create PivotTable dialog box to indicate the location for your pivot table. The de-
fault location is on a new worksheet, but you can specify any range on any worksheet, including the worksheet
that contains the data.
Click OK, and Excel creates an empty pivot table and displays its PivotTable Fields task pane, as shown in Fig-