Multiple Pivot Tables, Same Worksheet, Single Page Field

[Alan Whitehouse]

Hi,

I have an Excel spreadsheet with multiple worksheets in it, each with
different data. In all the worksheets there is a common element (Year).

I would like to create a master page that has multiple pivot tables in it.
However, at the top of the page I would like a single page field filter such
that when the user selects a year, all the pivot tables (4) on that
worksheet change without them having to change each pivot table.

Can this be done? If so, can someone point me in the right direction as to
how to do it?

Thanks.

Alan

 

[Debra Dalgleish]

There's a sample file here that changes the page field in related pivot
tables when the master table is changed:

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

Under 'Pivot Tables' look for 'Change Page Field'

It may help you get started.

 

[Alan Whitehouse]

I saw that one. I was hoping there was a way to do it without using code.
When you send these out to people you never know their security settings.
Thanks though.

Anyone else have any ideas?