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.