cpadilla0024
Member
Hi,
I am looking for an easy way to change the data source on multiple Pivot Tables in one shot. By easy I am hoping without VBA but if it must be, the most efficient way. I do fiscal oversight and I have tabs per site (up to about 15) per workbook and it would be nice if I can change them efficiently. I tried looking through ASAP Utilities and KuTools but I could not really find much.
Please help! Thanks!
I am looking for an easy way to change the data source on multiple Pivot Tables in one shot. By easy I am hoping without VBA but if it must be, the most efficient way. I do fiscal oversight and I have tabs per site (up to about 15) per workbook and it would be nice if I can change them efficiently. I tried looking through ASAP Utilities and KuTools but I could not really find much.
Please help! Thanks!