Thread: Filtering Data In several Tables at the same time.

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

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 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

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