Hello guys, does anyone out there know anything about automating pivot
table filters? I have a worksheet with several pivot tables and
associated pivot graphs in it. The data for all these tables is pulled
from the same source, a SQL table that contains sales information
(sales for each part are graphed separatly by sales rep). I am trying
to figure out a way that I can select the filter criteria (the field
drop down) for one table/graph and have it change for all of the
table/graphs in the workbook. Is this possible or am I spinning my
wheals here?

Thanks as always,
SQL_QT