| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
items disappearing from pivot dropdown when not selected
Hi,
In a pivot table, how do I ensure that items in the drop down lists remain on the list even when not selected. I.e. I want to be able to see all items on the list so that I can select them next time without going into the layout to add them again Thanks! |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
items disappearing from pivot dropdown when not selected
p.s. the items i am talking about are the 'Data' items (i.e. not the column
or row) "confused" wrote: Hi, In a pivot table, how do I ensure that items in the drop down lists remain on the list even when not selected. I.e. I want to be able to see all items on the list so that I can select them next time without going into the layout to add them again Thanks! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pivot Table dropping items from page item list | Excel Discussion (Misc queries) | |||
| Can't group pivot table items by month in Excel | Excel Discussion (Misc queries) | |||
| Pivot Options Disappearing! | Excel Discussion (Misc queries) | |||
| Pivot Tables, can I use an external list to select data items? | Excel Worksheet Functions | |||
| Pivot Table - Group by Month - Show Items with no data | Excel Discussion (Misc queries) | |||
Hybrid Mode
