| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Delete item from Pivot Table field?
After I've deleted data that I use in my pivot table/chart, how do I get rid
of the items that are still appearing in the drop down menus for each field? For example: I deleted a line because that person no longer work in this company, but their ID still appears in the USER ID field even though there are no more occurences of that item. |
|
#2
|
|||
|
|||
|
Hi,
Does Debra's explanation help, I'm sure it will. http://www.contextures.com/xlPivot04.html Cheers Andy Stephen wrote: After I've deleted data that I use in my pivot table/chart, how do I get rid of the items that are still appearing in the drop down menus for each field? For example: I deleted a line because that person no longer work in this company, but their ID still appears in the USER ID field even though there are no more occurences of that item. -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Help PLEASE! Not sure what answer is: Match? Index? Other? | Excel Worksheet Functions | |||
| Pivot table field types | Excel Discussion (Misc queries) | |||
| pivot table - hide details but show subtotal for calculated field | Excel Discussion (Misc queries) | |||
| Calculated Field in Pivot Table | Excel Worksheet Functions | |||
| Setting default pivot table field setting to "sum" | Excel Discussion (Misc queries) | |||
Linear Mode
