Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Multiple PivotTables
I am creating an analysis tool that will read multiple PivotTables that all
come from the same source. As I build the 5-6 PivotTables I use the same source data as PivotTable 1, thus saving space (in PivotTable wizard the first step asks "Where the data is that you want to analyze and I use the last option "Another PivotTable report"). However, when I update the range for PivotTable 1 it is not reflected in the other PivotTables. Is there a way to have all the other PivotTables update when I update the PivotTable 1 range? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
PivotTables | Excel Discussion (Misc queries) | |||
PivotTables | Excel Discussion (Misc queries) | |||
Multiple PivotTables on one spreadsheet | Excel Discussion (Misc queries) | |||
[pivottables] multiple table selection fields update in one click... | Excel Discussion (Misc queries) | |||
New to Pivottables- need help | Charts and Charting in Excel |