Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Good Morning,
I have two pivot tables driving a report. I'd like to link them -so that when I select a different market on the first pivot, it would make the change to both. Is this possible? Thanks in advance! |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Check out this link...
http://www.contextures.com/excelfiles.html Specifically at this section... PT0008 - Change Multiple Page Fields -- HTH... Jim Thomlinson "nacholibre" wrote: Good Morning, I have two pivot tables driving a report. I'd like to link them -so that when I select a different market on the first pivot, it would make the change to both. Is this possible? Thanks in advance! |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Thanks for the link Jim, for some reason the code isn't working when I make
changes to the pivot. I don't know how to read VBA, so I don't think I'll be able to make it work here. "Jim Thomlinson" wrote: Check out this link... http://www.contextures.com/excelfiles.html Specifically at this section... PT0008 - Change Multiple Page Fields -- HTH... Jim Thomlinson "nacholibre" wrote: Good Morning, I have two pivot tables driving a report. I'd like to link them -so that when I select a different market on the first pivot, it would make the change to both. Is this possible? Thanks in advance! |
#4
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I have tested taht code and it works great. Tghe firts thing I would check
would be your macro security setting Tools - Macros - Security (should be medium)... If you want more help with this just respond back... -- HTH... Jim Thomlinson "nacholibre" wrote: Thanks for the link Jim, for some reason the code isn't working when I make changes to the pivot. I don't know how to read VBA, so I don't think I'll be able to make it work here. "Jim Thomlinson" wrote: Check out this link... http://www.contextures.com/excelfiles.html Specifically at this section... PT0008 - Change Multiple Page Fields -- HTH... Jim Thomlinson "nacholibre" wrote: Good Morning, I have two pivot tables driving a report. I'd like to link them -so that when I select a different market on the first pivot, it would make the change to both. Is this possible? Thanks in advance! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Pivot Table Size | Charts and Charting in Excel | |||
Pivot Table Question | New Users to Excel | |||
Pivot Table Question | Excel Discussion (Misc queries) | |||
Need to Improve Code Copying/Pasting Between Workbooks | Excel Discussion (Misc queries) | |||
Jon Peltier - Pivot Table Result for yesterday's "Complex Chart" Question | Charts and Charting in Excel |