| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Question regarding pivot table selections
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
|
|||
|
|||
|
Question regarding pivot table selections
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
|
|||
|
|||
|
Question regarding pivot table selections
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
|
|||
|
|||
|
Question regarding pivot table selections
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 | |
|
|
Similar Threads
|
||||
| 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 | |||
Linear Mode
