Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Synchronizing Multiple Pivot Tables
I have multiple pivot tables based on the same data, and would like users to
be able to select certain Page field combinations and have all pivots automatically synchorize to that combination. My ultimate preference is to have some sort of user interface (e.g., form or separate sheet with drop-downs), but as a starting point, I'd be happy if I could just sync other tables based on one "master" pivot. Thanks, Todd |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Synchronizing Multiple Pivot Tables
Hi Todd,
I have made four posts with the same question. I've visited a web site by Debra Dalgleish and found one of her templates helpful although it updates only three pivot tables which are all found on one sheet. I have six pivot tables contained on their own worksheets (all in one workbook) and I'd like to update their page fields by a value in cell b4 in my summary sheet. Debora's solution updates three pivot tables by a central pivot table contained in the first worksheet. Here is the URL that I visited: http://www.contextures.com/excelfiles.html The sample template's coordinates on this website is: "PT0015 - Change Multiple Different Page Fields". If you figure out how to update 6 different pivot table page fields on 6 separate worksheets by one central drop-down list, please let me know. Cheers! Kent Lysell Financial Consultant IBM/Canada Revenue Agency Ottawa, Ontario W: 613.943.9098 "T. Jenkins" wrote: I have multiple pivot tables based on the same data, and would like users to be able to select certain Page field combinations and have all pivots automatically synchorize to that combination. My ultimate preference is to have some sort of user interface (e.g., form or separate sheet with drop-downs), but as a starting point, I'd be happy if I could just sync other tables based on one "master" pivot. Thanks, Todd |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Synchronizing Multiple Pivot Tables
I've added a sample workbook here, that changes all the pivot tables in
the workbook, when an item is selected from a data validation list in a cell: http://www.contextures.com/excelfiles.html Under PivotTables, look for 'PT0016 - Change Page Fields With Cell Dropdown' klysell wrote: Hi Todd, I have made four posts with the same question. I've visited a web site by Debra Dalgleish and found one of her templates helpful although it updates only three pivot tables which are all found on one sheet. I have six pivot tables contained on their own worksheets (all in one workbook) and I'd like to update their page fields by a value in cell b4 in my summary sheet. Debora's solution updates three pivot tables by a central pivot table contained in the first worksheet. Here is the URL that I visited: http://www.contextures.com/excelfiles.html The sample template's coordinates on this website is: "PT0015 - Change Multiple Different Page Fields". If you figure out how to update 6 different pivot table page fields on 6 separate worksheets by one central drop-down list, please let me know. Cheers! Kent Lysell Financial Consultant IBM/Canada Revenue Agency Ottawa, Ontario W: 613.943.9098 "T. Jenkins" wrote: I have multiple pivot tables based on the same data, and would like users to be able to select certain Page field combinations and have all pivots automatically synchorize to that combination. My ultimate preference is to have some sort of user interface (e.g., form or separate sheet with drop-downs), but as a starting point, I'd be happy if I could just sync other tables based on one "master" pivot. Thanks, Todd -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Synchronizing Multiple Pivot Tables
Thanks Debra!
-- Kent Lysell Financial Consultant Ottawa, Ontario W: 613.943.9098 "Debra Dalgleish" wrote: I've added a sample workbook here, that changes all the pivot tables in the workbook, when an item is selected from a data validation list in a cell: http://www.contextures.com/excelfiles.html Under PivotTables, look for 'PT0016 - Change Page Fields With Cell Dropdown' klysell wrote: Hi Todd, I have made four posts with the same question. I've visited a web site by Debra Dalgleish and found one of her templates helpful although it updates only three pivot tables which are all found on one sheet. I have six pivot tables contained on their own worksheets (all in one workbook) and I'd like to update their page fields by a value in cell b4 in my summary sheet. Debora's solution updates three pivot tables by a central pivot table contained in the first worksheet. Here is the URL that I visited: http://www.contextures.com/excelfiles.html The sample template's coordinates on this website is: "PT0015 - Change Multiple Different Page Fields". If you figure out how to update 6 different pivot table page fields on 6 separate worksheets by one central drop-down list, please let me know. Cheers! Kent Lysell Financial Consultant IBM/Canada Revenue Agency Ottawa, Ontario W: 613.943.9098 "T. Jenkins" wrote: I have multiple pivot tables based on the same data, and would like users to be able to select certain Page field combinations and have all pivots automatically synchorize to that combination. My ultimate preference is to have some sort of user interface (e.g., form or separate sheet with drop-downs), but as a starting point, I'd be happy if I could just sync other tables based on one "master" pivot. Thanks, Todd -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot tables - Editing the data source shared by multiple pivot ta | Excel Discussion (Misc queries) | |||
synchronizing data on multiple spreadsheets | Excel Worksheet Functions | |||
build a pivot table from multiple other pivot tables. | Excel Discussion (Misc queries) | |||
how do I consolidate multiple pivot tables into one pivot table? | Excel Discussion (Misc queries) | |||
synchronizing the years for multiple dates | Excel Discussion (Misc queries) |