help on pivot table
 

after building a pivot table and placing all the fields on its proper location,
i made changes on the source data "text only"

after refreshing the pivot table, i have seen it has been updated yet i am
still confused how to update the drop down list box...
any help is greatly appreciated..

--
*****
birds of the same feather flock together..

help on pivot table
 

There are instructions here for clearing old items from a pivot table:

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



dribler2 wrote:
after building a pivot table and placing all the fields on its proper location,
i made changes on the source data "text only"

after refreshing the pivot table, i have seen it has been updated yet i am
still confused how to update the drop down list box...
any help is greatly appreciated..



--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html

help on pivot table
 

thanks for the link Ms. Debra,

--
*****
birds of the same feather flock together..



"Debra Dalgleish" wrote:

There are instructions here for clearing old items from a pivot table:

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



dribler2 wrote:
after building a pivot table and placing all the fields on its proper location,
i made changes on the source data "text only"

after refreshing the pivot table, i have seen it has been updated yet i am
still confused how to update the drop down list box...
any help is greatly appreciated..



--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html