Flush old Excel Pivot Table Field Data

[bgentile]

Hello all,
I have an urgent request.
I've been changing the underlying data on a tab in an Excel 2003 pivot table that I use as the source and when I change a value from say TRUE/FALSE to Y/N, I now see all values of TRUE, FALSE, Y and N in the pivot field selection list.

Is there any way to flush out the old values? Excel seems to cache this somehow/somewhere and I can't figure out how to get ride of the old values.

Thanks much!
-Ben

 

[vconfused]

First hit on Google showed: http://www.contextures.com/xlPivot04.html

Let us know if it doesn't help.

 

[bgentile]

vconfused,
Thank you very much. It all seems so easy, once you know how.