Delete item from Pivot Table field?

S

Stephen

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Dealing with a Pivot Table (when I don't want to) 0
Display bug in Word: tables disappearing on copy and paste of text with bullet points into table 2
Slicers and Calculated Items in Pivot Table 2
Multiple charts from Pivot Table 0
Pivot Table Calculated Field 0
VBA works in orignal but fails in copy of database 1
Excel 2003 Pivot Table - deleted items still show in drop downs 1
VBA Pivot Table: Determining item from one field based on anotherfield item 0

Top