can i link pivot tables
 

I have two pivot tables that get there source data from different files. I
would like to link the fields from both pivot tables into one spreadsheet
that will update when the pivot tables are updated.

can i link pivot tables
 

Hope this gives you what you want:
http://www.contextures.com/xlPivot08.html

If that doesn't do it, look he
http://www.contextures.com/xlPivot07.html



--
RyGuy


"Peter" wrote:

I have two pivot tables that get there source data from different files. I
would like to link the fields from both pivot tables into one spreadsheet
that will update when the pivot tables are updated.