How do I remove items listed in a pivot table drop down list box
 

I'm working with a pivot table in Excel. The occurences of a specific value
in my source data for a pivot table have all been removed from the source /
raw data but the drop down list box for that field still shows that value as
an option to display. How can I get rid of this?

There are instructions here for clearing old items from a PivotTable
dropdown list:

http://www.contextures.com/xlPivot04.html


Hart165Hour wrote:
I'm working with a pivot table in Excel. The occurences of a specific value
in my source data for a pivot table have all been removed from the source /
raw data but the drop down list box for that field still shows that value as
an option to display. How can I get rid of this?


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

Right Click in Pivot Table. Then select "Refresh Data".

"Hart165Hour" wrote:

I'm working with a pivot table in Excel. The occurences of a specific value
in my source data for a pivot table have all been removed from the source /
raw data but the drop down list box for that field still shows that value as
an option to display. How can I get rid of this?

Visit Debra Dalgleish's site:
http://www.contextures.com/xlPivot04.html



Hart165Hour wrote:

I'm working with a pivot table in Excel. The occurences of a specific value
in my source data for a pivot table have all been removed from the source /
raw data but the drop down list box for that field still shows that value as
an option to display. How can I get rid of this?

--

Dave Peterson