Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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? |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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? |
#4
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to remove Drop Page Fields Here from Pivot Table | Excel Discussion (Misc queries) | |||
Pivot Table unable to Include Hidden Items In Subtotals | Charts and Charting in Excel | |||
Can't group pivot table items by month in Excel | Excel Discussion (Misc queries) | |||
Pivot Table - Group by Month - Show Items with no data | Excel Discussion (Misc queries) | |||
Problem with Pivot Table Drop-Down Menus | Excel Worksheet Functions |