There's a sample file here that you could adapt to your workbook:

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

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

MichelleO wrote:
Say I have 5 pivot tables that all have in the drop down menu "Geography" in
A4. I would like to know if excel has a capability to select say Americas
from the drop down box and the same be selected and updated for every pivot
you have within the file. I thought perhaps my hitting ctrl and selecting
all tabs and then selecting the geography I wanted it would work but it says
it cannot do that...Does anyone know if there is a solution?


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html