Prak05Copper ContributorJun 08, 2020Change data source of Pivot Tables without changing structure Hoe to change data source of Pivot Tables without changing structure?
wsantosBrass ContributorJun 30, 2020https://support.microsoft.com/en-us/office/change-the-source-data-for-a-pivottable-afd93524-f7de-432c-84d0-3896fbbc2577
dkvb1Copper Contributor to wsantosDec 21, 2022wsantos 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?
