Hello Excel Forum,

Are you guys able to provide a Macro for the following purposes:
  • Change all pivots with one filter/selection
  • Change data source of multiple pivots by changing one data source

for the 2nd ask if I have 5 Pivots and 3 work off one data source and the other 2 work of another one, I would like to be able to change data source for all like pivots by just changing it for one of them. So one change of data source for the 3 and one change of data source for the 2 other ones.

Sorry if that sounds confusing. Thank you for your time!