Pivot Table Fields

[Guest]

In my underlying data set that feeds a pivot table I've deleted some values.
When I go into the 'Hide Items' section of the pivot table wizard for this
field of values I still see those values that I deleted. It's making my
'Hide Items' list very long. How can I get rid of those values in the 'Hide
Items' list that are no longer in my data set?

Thx-Greg

 

[Guest]

Does it change if you update the PivotTable? You can hit the Red Exclamation
Point on the PivotTable toolbar to update the PivotTable to refelct changes
in the Data. I would try that, if you haven't already.

tj

 

[Guest]

Hi,
I believe you have 2 options:
1) Redo the pivot table
2) Check out the following site:
http://www.contextures.com/xlPivot04.html

 

[Guest]

Thanks mzehr!

I had to move the field out of the pivot table, refresh, and then move the
field back into the pivot table.