Manage 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 panel.

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 a 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.

To view the external data source information for the current pivot table, follow these steps:

1.In the Pivot Table Settings pane, on the Options tab, hover the cursor over the name of the external source in the Data Source box and click the button that appears.

2.In the drop-down menu, select Show Details.

To view details about any external data source added to the current document, follow these steps:

1.Open the list of sources.

2.In the list, find the desired source and click Details in the row with it.

In the External Data Source window that opens, you can view and edit information about the external source.

To change the information of an external source, follow the steps below:

1.Open the source information.

2.You can change the following information and parameters of the external source in the details window:

•Name: The name of the source that is displayed in the current document.

•Description: A detailed description of the source.

•File: The path to the source file. The current path can be copied to the clipboard using the button or set the path to another source using the Select File button.

•Sheet: Current sheet of the source with source data. You can select another source sheet using the Select Sheet button.

3.To save the changes made, click OK.

To add an external source to the list of sources in use, follow the steps below:

1.Open the list of sources.

2.In the External Data Sources window, click Add Source.

3.In the file manager window, select the source file.

4.In the Select Sheet window, select an external document sheet from the list and click OK. Clear the The first line of the data range contains titles checkbox if you do not want to use the first row as a title.

The selected source will appear in the list of the External Data Sources window, after which the window can be closed in any convenient way.

To delete an external source from the list of sources in use, follow the steps below:

1.Open the list of sources.

2.In the External Data Sources window, find the required source and click  Remove From List.

3.Confirm the deletion in the window that appears.