| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do i create multiple pivot tables with one field automatically
I'm trying to get a sheet for every single element of a field in a pivot table.
I know this is possible by double clicking in the field once it's located at the top of the pivot table. But i haven't been able to do it now and i was wondering if there's a certain option i should flag or unflagged. Thank you. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do i create multiple pivot tables with one field automatically
If you have at least one field in the page area, select a cell in the
pivot table, and on the pivot table toolbar, choose PivotTableShow Pages. Leonardo wrote: I'm trying to get a sheet for every single element of a field in a pivot table. I know this is possible by double clicking in the field once it's located at the top of the pivot table. But i haven't been able to do it now and i was wondering if there's a certain option i should flag or unflagged. Thank you. -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Refresh multiple pivot tables | Excel Discussion (Misc queries) | |||
| how do I consolidate multiple pivot tables into one pivot table? | Excel Discussion (Misc queries) | |||
| why do pivot tables create such huge files? | Excel Discussion (Misc queries) | |||
| Updating Page Field of Pivot Tables from Form Control | Excel Discussion (Misc queries) | |||
| merging multiple pivot tables | Excel Worksheet Functions | |||
Linear Mode
