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. |
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 |
All times are GMT +1. The time now is 01:15 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com