Hi,
I have a pivot table connected by an Access db as source data and is working fine. But the constraint is that the location of the Access(.mdb) file has been changed to a new folder, as a result my pivot is not getting updated or refreshed. I tried to find out the source using the Get Data button but with no success.
Could someone help me in finding the source path and changing the source to the new path of the .mdb file location using VBA macro.
Thanks in advance for your help.