Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Change Pivot Table Row Value on Multiple Tables
Thank you to anyone that can help me out with this request.
I have a workbook that contains three different pivot tables based on different data, yet one criteria (Type) is the same throughout all of them. I would like to select multipe values from "Type" on one table (on the main/first sheet) and have that update the "Type" for each of the other tables in my workbook. I have an example file that shows how to do this when based off the same data and if you use page fields, but I don't have that built this way since it is different data for each. Also, I can't combine the data into one sheet because it is too much for Excel to handle. Additionally, I have the pivot tables built off a database in Access. Can what I am looking to do be done? Please let me know. I appreciate it. Conor Finnegan |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot Table Data Adding contents of two pivot tables and param que | Excel Discussion (Misc queries) | |||
Change Multiple Page Fields in two independent Pivot Tables | Excel Worksheet Functions | |||
build a pivot table from multiple other pivot tables. | Excel Discussion (Misc queries) | |||
Pivot Tables -changing datasource for exsting Pivot Table | Setting up and Configuration of Excel | |||
how do I consolidate multiple pivot tables into one pivot table? | Excel Discussion (Misc queries) |