Linking a pivot table filter to a control cell

B

Bob Freeman

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.
 
B

Bob Freeman

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pivot Tables/Charts and common filter 1
Single Filter to change all Pivot Tables in a Workbook 8
PIVOT - Reference a cell outside the table for report filtering 2
pivot tables 4
pivot table filter 6
Pivot Table Ranges 8
Pivot Table Clear All Filters 8
Linking chart title to a cell 2007 2

Top