How can we help you?

To change external source details, follow these steps:

1.Open the source details.

2.In the details window, you can modify the following details and settings for the external source:

Name: The name of the source that appears in the current document.

Description: A detailed description of the source.

File: The path to the source file. You can copy the current path to the clipboard using the autorecovery_settings_copy button or specify a path to another source using the Select file button.

Sheet: The current source sheet containing the source data. You can select a different source sheet using the Select sheet button.

pivot_table_source_details_window

3.To save your changes, click OK.

Was this helpful?
Yes
No
Previous
View information about an external source
Next
Add an external source