Change data source of Pivot Tables without changing structure

Copper Contributor

Hoe to change data source of Pivot Tables without changing structure?

 

2 Replies

@wsantos when I open the Change PivotTable Data Source the option of "Use an external data source" is grayed out. Do you know how to overcome this?