Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#2
|
|||
|
|||
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:
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.
__________________
I am not human. I am an Excel Wizard |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Filter lines with Pivot table and non Pivot table columns | Excel Discussion (Misc queries) | |||
Filter lines containing pivot table and non pivot table data | Excel Worksheet Functions | |||
linking cell to Pivot Table data | Excel Worksheet Functions | |||
linking pivot table data to a cell in other sheet | Excel Worksheet Functions | |||
GETPIVOTDA - Linking Into Pivot-table Cell | Excel Discussion (Misc queries) |