View the list of external sources

You can view a list of all external sources linked to the current document in one of the following ways:

•Using the settings pane of the pivot table:

1.Open the pivot table settings pane.

2.Hover the cursor over the name of the external document in the Data source box and click the button that appears. In the drop-down menu, select Replace.

•Using the pivot table creation window:

1.Open the pivot table creation window to create a pivot table based on data from an external source.

2.In the Create pivot table window, click Select source.

The External data sources window lists all the sources linked to the current document and allows you to view information about each of them, change this information, add new sources and delete existing ones.