Using Data from an Existing Data Connection

1. Click the PivotTable button on the Insert ribbon to display the Create PivotTable dialog box (shown earlier in Figure 2-1).
2. Select the Use an External Data Source option, and click the Choose Connection button to open the Existing Connections dialog box (shown earlier in Figure 2-4).
3. Click the data source that you want to use.
4. Click OK.

At this point one of two things will happen, depending on the nature of the data source. If the data source contains a single table of data, Excel will create the blank PivotTable and display the PivotTable field list, and you can proceed with the PivotTable design. If, however, the data source contains more than one table, Excel will display the Select Table dialog box listing the available tables, as shown in Figure 2-6. You must click the table that you want to base your PivotTable on; then click OK to create the blank PivotTable and display the PivotTable Field List.

Figure 2-6: Selecting the table that you want the PivotTable to be based on.

Leave a Reply