Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
It is kinda tricky to make a multiple pivot table, but I found out. By the
way ribbon are great but are not showing all the possibilities of excel 2007. In excel presse F1. Make a search on Consolidate multiple worksheets into one PivotTable report Then choose Consolidate data without using page fields You will discover then that you can acess a PivotTable and PivotChart Wizard, press ALT+D+P. Good luck. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Data Validation with multiple table selection | Excel Discussion (Misc queries) | |||
[pivottables] multiple table selection fields update in one click... | Excel Discussion (Misc queries) | |||
Selection of multiple values for pivot table field | Excel Discussion (Misc queries) | |||
multiple pivots updated with selection in one table | Excel Worksheet Functions | |||
Multiple selection in the page area of a pivot table | Excel Discussion (Misc queries) |