Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Linking excel pivot tables
Does anybody know how to link a page selcetion from one pivot table e.g
female to another pivot table so the linked pivot would show the "female" data too? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Linking excel pivot tables
You can use programming to link the page fields. There are sample files
he http://www.contextures.com/excelfiles.html Under Pivot tables, look for 'Change Multiple Page Fields' and 'Change Page Field' wrote: Does anybody know how to link a page selcetion from one pivot table e.g female to another pivot table so the linked pivot would show the "female" data too? -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sorting in Excel 2000 Pivot Tables | Excel Discussion (Misc queries) | |||
Pivot Tables in Excel 2000 | Excel Discussion (Misc queries) | |||
Ho to Delete "Ghost" Pivot Tables | Excel Discussion (Misc queries) | |||
Excel Pivot tables refresh | Excel Worksheet Functions | |||
Product Function in Pivot Tables from Multiple Consolidation Range | Excel Worksheet Functions |