How can we help you?

If you want to change the data source of a table created from the data in the current file, follow these steps:

1.Place the cursor in the Data source box. The source table tab will open in the document and the value in the Data source box will be available for editing. The specified data range will be highlighted in the source table in color.

2.Edit the value in the Data source field and click the accept_icon button or press Enter.

If you want to change the data source of a table that was created from an external source, follow these steps:

1.Move the cursor over the name of the external source in the Data source box and click the side_panel_macro_more button. In the menu that opens, select Replace.

2.In the External data sources window, select another external source from the list or add a new one and click OK.

Changing the external source is not available when working in the cloud.

 

Was this helpful?
Yes
No
Next
Select the pivot table layout