Change link in pivot table

  • Thread starter Thread starter csimon
  • Start date Start date
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.
 
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:

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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pivot Table with Data Model Connection - getpivotdata reference issue 0
Link Drop Down with Pivot Table 2
Pivot table data source 1
Average of Subtotals in Pivot Table 0
grouping dates in a pivot table 1
Excel VBA For excel 0
Way 4
Relinking Pivot Tables to Main Table 1

Back
Top