pivot table refresh
 

hi,

i have a pivot table based on another pivot table. the page fields are
exactly the same, but the data is different. i would likt to know how i can
get the second pivot table's page selections to change when i select
options/values from the first pivot table. it would seem loike this would be
automatic if the second pivot table is based on the first.

thanks in advance,
geebee