Linking pivot tables across worksheets

[voodoo.mutt]

Hi

I would like to link two (or more) pivot tables that are sitting on individual worksheets. The datasets are separate however they share a common pagefield.

So if I change the filter in Pivot Table 1 on Worksheet One to "Apples" then I'd to see Pivot Table 2 on Worksheet Two also change it's filter to "Apples" and refresh accordingly.

I've found VB code for syncing pagefields for pivot tables sharing the same worksheet but nothing across worksheets.

Any ideas?

Thanks in anticipation.

 

[JD_GFI]

If you are using Excel 2010 then you can use a slicer to filter all pivot tables using a common pivot cache. Just create your slicer and then add any other tables under its "Pivot table connections" setting.

 

[voodoo.mutt]

Thank you. Unfortunately work is using excel 2003

 

[Hermanito]

post the code you found, it can probably be adapted for your case...

 

[voodoo.mutt]

hi, here is the code which works for two pivots on one worksheet

Private Sub Worksheet_Calculate()
Dim PF1 As PivotField
Dim PF2 As PivotField
Dim x As String
Application.EnableEvents = False
Application.ScreenUpdating = False
Set PF1 = ActiveSheet.PivotTables("<wbr>PivotTable1").PageFields(1)
Set PF2 = ActiveSheet.PivotTables("<wbr>PivotTable2").PageFields(1)
x = PF1.CurrentPage
PF2.CurrentPage = x
Application.ScreenUpdating = True
Application.EnableEvents = True
End Sub

thank you

 

[Kim25]

I have done this using the following method:

http://www.datapigtechnologies.com/flashfiles/pivot10.html


Works really well.

 

[voodoo.mutt]

I have done this using the following method:
.

but this method seems to only work for multiple pivots on one worksheet. not several pivots on individual worksheets

 

[Kim25]

My pivot tables are all on different worksheet

 

[voodoo.mutt]

ok tried again. yep this solution does the trick, thanks.