Change a Pivot Table Report Filter Using a Data Validation List

Hi, Louis

You could use VBA. Please refer http://www.contextures.com/excelfiles.html#Pivot

Fully automatic without VBA will be limiting, such as set up the pivot table to query external data and refresh every n minutes.

Or, you could have minimal VBA (just one line?) to refresh of pivot tables on change to either of the data validation cells. For this, set up the pivot tables by joining the current source data with the data validation cells. SQL like below. VBA would be something like this pseudo code

sub worksheet_change(target as range)
if to identify target is year or month data validated cell then wbk.refreshall
end sub

HTH, Fazza

Thanks Fazza, there is a workbook in the link you included that has an example of exacty what I want to achieve.
http://www.contextures.com/PivotMultiPagesCellChange.zip

Brilliant, thanks.

I am trying to run this code, but it's not working....even on the sample excel file that is provided in post# 3. Any idea why the code is not running? Thanks

Hi,

Look like the kind of codes I am looking for but sadly when I open the excel file from which the link is in this discussion, it doesn't work. I tried to implement it on my huge file and it doesn't either.. any idea why??