software

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: www.excelforum.com/member.php...oamp;userid=34231
View this thread: www.excelforum.com/showthread...hreadid=539862Right click on the pivot table, choose the wizard, then back up until you
get to the place where you specify the source data.

--
Carlos

quot;csimonquot; gt; wrote in
message ...
gt;
gt; How do you change an existing link in a pivot table to a new link in the
gt; same pivot table? I have a pivot table linked to an Access Dbase but
gt; need to change it to a new Access Dbase.
gt; Thanks.
gt;
gt;
gt; --
gt; csimon
gt; ------------------------------------------------------------------------
gt; csimon's Profile:
www.excelforum.com/member.php...oamp;userid=34231
gt; View this thread: www.excelforum.com/showthread...hreadid=539862
gt;

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!--
csimon
------------------------------------------------------------------------
csimon's Profile: www.excelforum.com/member.php...oamp;userid=34231
View this thread: www.excelforum.com/showthread...hreadid=539862