Change link in pivot table

C

csimon

How do you change an existing link in a pivot table to a new link in the
same pivot table? I have a pivot table linked to an Access Dbase but
need to change it to a new Access Dbase.
Thanks.
 
C

CarlosAntenna

Right click on the pivot table, choose the wizard, then back up until you
get to the place where you specify the source data.
 
C

csimon

Carlos:

I tried that, but when I back up to select the external data sourc
that I want, it just asks me what columns I want to include in m
query. It doesn't give me the option to change to a new Dbase source.
I can't select a new Access Dbase.

Thanks
 
Top