Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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.. |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I sort pivot table data outside a pivot table | Excel Worksheet Functions | |||
Display the source for a pivot table page field | Excel Worksheet Functions | |||
Top 5 plus Other in Pivot table | Excel Worksheet Functions | |||
Derived Columns in Pivot Table | Excel Discussion (Misc queries) | |||
Pivot -- want to use Max and Sum in same table | Excel Worksheet Functions |