Multiple Pivot Tables, Same Worksheet, Single Page Field

  • Thread starter Thread starter Alan Whitehouse
  • Start date Start date
A

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
 
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?
 
Back
Top