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.

Answer: Linking a pivot table filter to a control cell
 

Yes, you can definitely link a pivot table filter to a control cell in Excel. Here are the steps to do so:

1. First, select the cell where you want to create the control cell. This cell will be used to control the pivot table filter.
2. Next, go to the "Data" tab in the Excel ribbon and click on "Data Validation".
3. In the "Data Validation" dialog box, select "List" as the validation criteria.
4. In the "Source" field, enter the list of filter options that you want to use. For example, if your filter options are "Sector 1", "Sector 2", and "Sector 3", you would enter those options separated by commas.
5. Click "OK" to close the dialog box.
6. Now, go to the pivot table that you want to link to the control cell. Click on the drop-down arrow next to the filter that you want to link.
7. In the drop-down menu, select "Report Filter Value Filters Equals".
8. In the "Equals" dialog box, click on the cell where you created the control cell in step 1.
9. Click "OK" to close the dialog box.
10. Repeat steps 6-9 for each pivot table that you want to link to the control cell.

Now, when you change the value in the control cell, all of the linked pivot tables will update to reflect the new filter selection. This will save you a lot of time and effort when working with multiple pivot tables that use the same filter.

Linking a pivot table filter to a control cell
 

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.

Linking a pivot table filter to a control cell
 

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.