macro to update several pivots from multiple data sources based on same value from slicer

[dmitrij]

Hey guys,

This issue drives me crazy.
I want two pivots from two different data sources to be updated based on one common value that's on a slicer. The update on the pivot A will trigger update on pivot B using PivotTableChangeSync.
I tried multiple alternatives and options, but non is working! Here's the code I found (and slightly modified). Source: http://www.kubiszyn.co.uk/one-slicer...ot-tables.html

Please help, as this little issue drives me crazy & I cannot understand why it's not working because it seems like everything is fine with data, page fields, names, etc.

Please Login or Register  to view this content.

Any ideas what might cause the macro not work? Maybe some advice on where I should draw my attention to?

[dmitrij]

bump...........

[dmitrij]

again bumping

[dmitrij]

anyone who could come up with a solution?

[dflak]

I think part of the reason nobody is responding is that you have not included a sample spreadsheet. Even if I had the time, I can't visualize your situation well enough to recreate it.