Filtering Data In several Tables at the same time.

[sql_qt]

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]

There are sample files here:

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

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

 

[sql_qt]

Debra thanks for the info but when pulling from SQL, the code fails
because it can not locate the data. It works fine if the data is in
the worksheet or another worksheet. Any sugestions?

Thanks