How do I remove "old" drop-down menu items in pivot table?
Posted by Mark Lyons on February 19, 2001 4:10 PM
I've researched this problem for days, but cannot find what should be a simple solution. Please help!
For some reason, items that were part of the "old" database are still showing up in the Pivot Table Buttons drop down menu. For example, if the pivot table source data contained a field called "Region" and one of the items was "Southwestern" it should show up under the drop-down "Region" button menu if, indeed, it is included in at least one record of the database. On the other hand, if the item "Southwestern" is no longer an item under the "Region" field (in any record), it SHOULD NOT show up under the drop-down "Region" button menu any longer (at least in my opinion). My actual problem is much larger because the data changes constantly ... because of this I end up with maybe 100 possible drop down button menu choices even though the actual possible choices should be 25-30. You would think a "Refresh" command would immediately correct this problem, but it does not. I am using Excel 200. What am I doing wrong?