Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Update pivottables
Is it possible to update (here understood as changing an element of a field)
in more than one table with one operation only, or do all tables have to be updated manually? For instance, if I have several pivottables with a 'Country' field in the page section and I want to update all from, say. Germany to France, can that be done in one operation? |
#2
|
|||
|
|||
You can do this with programming. There's a sample file he
http://www.contextures.com/excelfiles.html#Pivot Under PivotTables, look for 'Change Page Field' Henrik wrote: Is it possible to update (here understood as changing an element of a field) in more than one table with one operation only, or do all tables have to be updated manually? For instance, if I have several pivottables with a 'Country' field in the page section and I want to update all from, say. Germany to France, can that be done in one operation? -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
#3
|
|||
|
|||
I can see how it works in the example file -- now how do I get it to work on
my file as well? Didn't show up as an add-in... "Debra Dalgleish" wrote: You can do this with programming. There's a sample file he http://www.contextures.com/excelfiles.html#Pivot Under PivotTables, look for 'Change Page Field' Henrik wrote: Is it possible to update (here understood as changing an element of a field) in more than one table with one operation only, or do all tables have to be updated manually? For instance, if I have several pivottables with a 'Country' field in the page section and I want to update all from, say. Germany to France, can that be done in one operation? -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
#4
|
|||
|
|||
To adapt the code to your workbook:
Right-click on the Sales Pivot sheet tab, and choose View Code Copy all the code Switch to your workbook, and right-click on the main pivot table sheet tab, and choose View Code Paste the copied code. In the code, change the references to match your workbook. For example, change: strField = "Item" to the name of your page field, and change the worksheet name: Set wsOther = Sheets("Other Pivots") to match the sheet name where your secondary pivot tables are located. Henrik wrote: I can see how it works in the example file -- now how do I get it to work on my file as well? Didn't show up as an add-in... "Debra Dalgleish" wrote: You can do this with programming. There's a sample file he http://www.contextures.com/excelfiles.html#Pivot Under PivotTables, look for 'Change Page Field' Henrik wrote: Is it possible to update (here understood as changing an element of a field) in more than one table with one operation only, or do all tables have to be updated manually? For instance, if I have several pivottables with a 'Country' field in the page section and I want to update all from, say. Germany to France, can that be done in one operation? -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html -- 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 | |||
Update links prompt not wanted | Excel Discussion (Misc queries) | |||
keep value from last update and don't ask to update links | Excel Discussion (Misc queries) | |||
Copy cell format to cell on another worksht and update automatical | Excel Worksheet Functions | |||
Edit Links: make update manual | Excel Discussion (Misc queries) | |||
Update Individual Links | Excel Discussion (Misc queries) |