Pivot Table Fields

G

gramos14

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
 
T

tjtjjtjt

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
 
G

gramos14

Thanks mzehr!

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