Hi all, thanks for any help you can provide.

When using a pivot table, I some times filter out a specific entry by
un-checking the drop down menu on a row field. I have noticed that there is
data stored on this drop down lists that is no longer in the source data.

Lets say I have a row for my vendors: Jessie, Lue, Bob, John and Jose, at
some point I entered Jessie's name with only one s (Jesie) and it appear as
such in the chart, Jessie brought to my attention that her name had two "s"
and so I changed all of Jessies entrys with the correct spelling. I can still
see "Jesie" in the drop down list on the vendor column, even when it no
longer exists on the source data...

I made all this up just to explain the case, how ever the situation is the
same and it creates problems on the real data. Is there a way to clean out
the data on this drop down lists to show only the existing data on the source?

Cheers,
Juan

check out this website for the info you're looking for...

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


On Mar 3, 11:47 am, Juan <J...@discussions.microsoft.com> wrote:
> Hi all, thanks for any help you can provide.
>
> When using a pivot table, I some times filter out a specific entry by
> un-checking the drop down menu on a row field. I have noticed that there is
> data stored on this drop down lists that is no longer in the source data.
>
> Lets say I have a row for my vendors: Jessie, Lue, Bob, John and Jose, at
> some point I entered Jessie's name with only one s (Jesie) and it appear as
> such in the chart, Jessie brought to my attention that her name had two "s"
> and so I changed all of Jessies entrys with the correct spelling. I can still
> see "Jesie" in the drop down list on the vendor column, even when it no
> longer exists on the source data...
>
> I made all this up just to explain the case, how ever the situation is the
> same and it creates problems on the real data. Is there a way to clean out
> the data on this drop down lists to show only the existing data on the source?
>
> Cheers,
> Juan

Thanks, I found what I was looking for!!

"Tim879" wrote:

> check out this website for the info you're looking for...
>
> http://www.contextures.com/xlPivot04.html
>
>
> On Mar 3, 11:47 am, Juan <J...@discussions.microsoft.com> wrote:
> > Hi all, thanks for any help you can provide.
> >
> > When using a pivot table, I some times filter out a specific entry by
> > un-checking the drop down menu on a row field. I have noticed that there is
> > data stored on this drop down lists that is no longer in the source data.
> >
> > Lets say I have a row for my vendors: Jessie, Lue, Bob, John and Jose, at
> > some point I entered Jessie's name with only one s (Jesie) and it appear as
> > such in the chart, Jessie brought to my attention that her name had two "s"
> > and so I changed all of Jessies entrys with the correct spelling. I can still
> > see "Jesie" in the drop down list on the vendor column, even when it no
> > longer exists on the source data...
> >
> > I made all this up just to explain the case, how ever the situation is the
> > same and it creates problems on the real data. Is there a way to clean out
> > the data on this drop down lists to show only the existing data on the source?
> >
> > Cheers,
> > Juan
>
>