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?