I created many pivot tables in a single excel file and it is connected to external data source.
They are come from the same data source file.
In stead of changing the external data source file one-by-one, any shortcut for these steps?