View information about an external source

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.