Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I have three pivot tables in my workbook,in separate worksheet.
Their data come from the same source.The pivot table differential is the layout,but all of them use the same field as the page,I want if I select a page from one of them another two pivot tables will also dispaly the same page.Is this possible.Thank's in advance. |
#2
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
You can do that with programming. There are sample files he
http://www.contextures.com/excelfiles.html Under PivotTables, look for: 'PT0016 - Change Page Fields With Cell Dropdown' 'PT0008 - Change Multiple Page Fields' 'PT0003 - Change Page Field' shiro wrote: I have three pivot tables in my workbook,in separate worksheet. Their data come from the same source.The pivot table differential is the layout,but all of them use the same field as the page,I want if I select a page from one of them another two pivot tables will also dispaly the same page.Is this possible.Thank's in advance. -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Pivot Table Show Pages On Same WorkSheet | Excel Worksheet Functions | |||
Show pages without using pivot table | Excel Discussion (Misc queries) | |||
Pivot Table help - select pages | Excel Discussion (Misc queries) | |||
Pivot table keeps dupping to another linked pivot table | Excel Discussion (Misc queries) | |||
What happened to Pivot Table "Show Pages"? | Excel Discussion (Misc queries) |