Using External Data
To use external, perform the following:
- Select Use an External Data Source.
- Select Choose Connection.
Note: Excel displays the Existing Connections dialog box.
- In the Show drop-down list box, select the category to choose a connection or select All Existing Connections.
Note: All Existing Connections is the default option.
- Select a connection from the Select a Connection list box.
- Click Open.
Note: If you choose a connection from the Connections in this Workbook category, you will be reusing or sharing an existing connection.
Note: If you choose a connection from the Connection files on the Network or Connection files on this computer categories, Excel copies the connection file into the workbook as a new workbook connection. Then uses that file to create a new connection from the PivotTable report.
Note: Additional information can be found at Manage Connections to data in a workbook.
- Perform one of the following to specify a location:
- To place the PivotTable report in a new worksheet starting at cell A1, select New Worksheet.
- To place the PivotTable report in an existing worksheet, perform the following:
- Select Existing Worksheet.
- Specify the first cell in the range of cells where the PivotTable report is to be placed.
- Collapse the Dialog box, and perform the following:
- Select the beginning cell on the worksheet.
- Select Expand Dialog box.
- Click OK.
Note: Excel adds an empty PivotTable report to the specified location and displays the PivotTable field list to add additional fields, create a layout, and customize the PivotTable report.
Note: Additional information can be found at Overview of PivotTable and PivotChart Reports and Create and Change the Layout of Fields in a PivotTable Report.
Note: If you create a PivotChart report, Excel creates an associated PivotTable report directly beneath the PivotChart Report.
Note: A PivotChart report is required to be in the same workbook.