View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Bob Freeman Bob Freeman is offline
external usenet poster
 
Posts: 20
Default Linking a pivot table filter to a control cell

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.