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.

–Using the pivot table creation window.

To view the list of external sources via the settings panel, follow these steps:

1.Open the pivot table settings pane.

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

To view a list of external sources in the pivot table creation window, follow these steps:

1.Open the window for creating 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 contains a list of all sources connected to the current document and allows you to view details about each one, edit those details, add new sources, and delete existing ones.