| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can you have two pivot tables on one worksheet?
To uncouple multiple PivotTables,
convert the common source List/Table into a range and give the same range two or more different defined names. (Include header range) Go to the source definition for each PT and enter a different source name for each PT. Turn the source range back into a Excel 2007 Table or Excel 2003 List. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Multiple Pivot Tables in same worksheet | Excel Worksheet Functions | |||
| Building pivot tables in Excel 2007 based on existing pivot tables? | Excel Discussion (Misc queries) | |||
| drill down worksheet placement (pivot tables) | Excel Discussion (Misc queries) | |||
| Two pivot tables on the same worksheet? I need help... | Excel Worksheet Functions | |||
| How does the term 'pivot' apply to Excel's Pivot tables and Pivot. | Excel Discussion (Misc queries) | |||
Hybrid Mode
