Thank you Jim.

I used PivotMultiPagesChangeAll.zip and it worked perfectly - this will
save a great deal of time and has shown me an area of excel I have not
previously used.

Best wishes,

Bob

"Jim Thomlinson" wrote:

Check out this link. there are some good examples here...

http://www.contextures.com/excelfiles.html#Pivot
--
HTH...

Jim Thomlinson


"Bob Freeman" wrote:

Hello,

I have a report with 10 different pivot table charts - each has the same
filter which I have to change when I am looking at a diferent sector. Is
there a way of linking this into a control cell so that I only have to make
the change once?

Any help gratefully received.