Updating Pivot Table source references

  • Thread starter Thread starter Tomek
  • Start date Start date
T

Tomek

I have two files, one with the source data and the other with many pivot
tables.
After changing the pivot table directory it expects the source data to be
changed consequently.

With the "normal" range links you can use Edit>Links.

Is there a way to change the source references in a pivot table e.g. change
the source name or directory?

Thanks,
Tomek
 
I think that if you just go to the pivotwizard and
click "back", it shows you the source data path. Just
edit there. Didn't try, but would guess it should work.

boris
 
Tomek -

You can name the range that is used for each pivot table's source data,
and enter this name, not the cell addresses, into the appropriate box
when first creating (or subsequently changing) the pivot table. When
the data changes, rename the range to include the new source data range,
or use dynamic ranges which automatically adjust to the size of the
range. Then you just need to click the Update Table button (the big red !).

- Jon
 
Back
Top