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.