Pivot Table Refresh Updating all to same data

  • Thread starter Thread starter Cydney
  • Start date Start date
C

Cydney

I have the same 3 pivot tables on 5 sheets. Each of them references data that
is on their own sheet (with a named range). The sheets were derived by
creating my data and pivot tables with a one-cell parameter and then copying
that to sheets, giving each a new name and changing the parameter. When I
update the pivot table on one, it updates to the same data on all sheets. How
can I make them look at the data on their own sheet? When I check the range
it's referencing, it shows me the named range on the appropriate sheet. But
it doesn't seem to actually be doing that.
 
Could this have something to do with phantom links? I can't see that there is
a problem, but there apparently is one. If it is phantom links, how can I
find them and remove/change them?
 
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

Code to Refresh inbound data sheets, then Refresh Pivot Tables 3
Pivot Table Question 2
Automatically Update a Pivot Table Field Used as Column / Row 1
Playing back a Pivot Table macros 2
macro updating imported data and pivot tables 2
refresh multiple pivot tables in workbook 2
Refreshing external data on individual sheets in a specific sequen 1
Copy PIVOT table? 5

Back
Top