Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot Table Change Macro
I have a worksheet with 4 different pivottables on it. I would a macro that
will change all pivottables when I chance the selection of 1 of the pivottables. So if I was change the Page selection in pivot 1, it would change the Page in the remaining 3 pivots to the same value. Any help is appreciated thanks. Vick |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot Table Change Macro
hi Vick
Take a look here http://www.contextures.com/excelfiles.html#Pivot Debra has several demo files to download which carry out this functionality PT0021 - Change All Page Fields -- Change any page field in the main pivot table, and the same selections are made in all pivot tables that contain the same page fields. Excel 2002 and later versions. PivotMultiPagesChangeAll.zip 17 kb 04-May-08 PT0016 - PT0015 - Change Multiple Different Page Fields -- Change either page field in the main pivot table, and the same selection is made in other pivot tables page fields (if available), where some field names are different. Excel 2002 and later versions. PivotMultiPagesDiffChange.zip 20 kb PT0016 - Change Page Fields With Cell Dropdown -- Select an item from a data validation dropdown, and all pivot tables in the workbook show that selection in the page field. Excel 2002 and later versions. PivotMultiPagesCellChange.zip 20 kb 15-Jun-07 -- Regards Roger Govier "Vick" wrote in message ... I have a worksheet with 4 different pivottables on it. I would a macro that will change all pivottables when I chance the selection of 1 of the pivottables. So if I was change the Page selection in pivot 1, it would change the Page in the remaining 3 pivots to the same value. Any help is appreciated thanks. Vick |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
change/set pivot table autofilter criteria with macro button | Excel Discussion (Misc queries) | |||
I tried to get around the problem of the pivot table field settingdefaulting to Count instead of Sum by running a macro of change the settingfrom Count to Sum. However, when I tried to run the Macro, I got error messageof run time error 1004, unable | Excel Worksheet Functions | |||
I tried to get around the problem of the pivot table field settingdefaulting to Count instead of Sum by running a macro of change the settingfrom Count to Sum. However, when I tried to run the Macro, I got error messageof run time error 1004, unable | Excel Discussion (Misc queries) | |||
Change pivot table source data via macro | Excel Discussion (Misc queries) | |||
Macro to change a Pivot Table | Excel Discussion (Misc queries) |