Syncronizing Multiple Pivot Tables from single filter

[greynolds]

I know this is a common issue and i have found a few solutions but none that i have been able to get to work for me. IF anyone has a code that on the change of a filter on the first pivot table the filter on the rest of my pivot tables also see this change. I have not yet found a working code for multiple filter changes for pivot tables either on seperate ws's or on the same ws.

any help would be greatly appreciated,
Gordon R

 

[Greg Truby]

Welcome to MrExcel.

Assuming that by "filter" you mean "filter" as used in Excel 2007 (termed a "page field" in previous versions of Excel) then this should help:

http://www.mrexcel.com/forum/showthread.php?t=305413