There are sample files he

http://www.contextures.com/excelfiles.html

Under Pivot tables, look for 'Change Multiple Page Fields' and 'Change
Page Field'


sql_qt wrote:
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



--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html