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!
Bookmarks