Hi Everyone,

this is my first post, hopefully not a major problem just me being rubbish.

ok, I have a worksheet full of data, on a seperate worksheet I have 3 pivot tables all using the same data all with the same page field. is there any way to connect the page fields so that I can have just one selection and all 3 pivot table will refresh with relevant information, rather than having to select the same field 3 times to see the data?

many thanks in advance