Change link in pivot table

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.

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

--
Carlos

"csimon" <csimon.27hu9b_1147099810.0177@excelforum-nospam.com> wrote in
message news:csimon.27hu9b_1147099810.0177@excelforum-nospam.com...
>
> 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.
>
>
> --
> csimon
> ------------------------------------------------------------------------
> csimon's Profile:
http://www.excelforum.com/member.php...o&userid=34231
> View this thread: http://www.excelforum.com/showthread...hreadid=539862
>

Carlos:

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

Thanks!