Hi colleagues,
Source connection to my pivots are all queried data but anytime i change the one of the pivot table connection the other pivots connection does not change.
I tried recording a macro whilst changing the connection of the pivot table but this looks tedious since i have to change the pivot table names manually in the codes.
Please how can I use vba to change the connection to the pivots once so that all the pivots will is linked to one connection and refreshes anytime one first pivot is refreshed.
Thank you
Source connection to my pivots are all queried data but anytime i change the one of the pivot table connection the other pivots connection does not change.
I tried recording a macro whilst changing the connection of the pivot table but this looks tedious since i have to change the pivot table names manually in the codes.
Please how can I use vba to change the connection to the pivots once so that all the pivots will is linked to one connection and refreshes anytime one first pivot is refreshed.
Thank you