How to change Pivot table datasource for multiple Pivot Tables at once without using VBA or code

Copper Contributor

I have a number of users who have been using the same underlying datasource for sometime, creating lots of Pivot tables in the same workbook.


We are movining our Cloud data to a new location, and need to give them a URL string and data connection. Is it possible to change all of the Pivot table data connections in the workbook at once without using and VBA or any other code and do this in Exce?


Otherwise, what might be the easiest script they could run to batch change their Pivot table datasource?

0 Replies