| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot Table Refresh?
Excel2003 ... Pivot Table & Chart working fine ... (Excel Range A1:P40000)
Above said ... I repopulated Table Source Range with new data (4 pns only instead of many) ... then I "Refreshed Data" ... Table appears fine ... Issue ... All the drop-down Filter Switches still contain the many pns from the previous data instead of the 4 I only wish to see now ... Same holds for the other Cols as well (Table looks fine ... But Filter drop-downs are showing old data)??? How do I get the drop-downs to "Refresh"? ... Thanks ... Kha |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Pivot Table Refresh?
check out this link...
http://www.contextures.com/xlPivot04.html -- HTH... Jim Thomlinson "Ken" wrote: Excel2003 ... Pivot Table & Chart working fine ... (Excel Range A1:P40000) Above said ... I repopulated Table Source Range with new data (4 pns only instead of many) ... then I "Refreshed Data" ... Table appears fine ... Issue ... All the drop-down Filter Switches still contain the many pns from the previous data instead of the 4 I only wish to see now ... Same holds for the other Cols as well (Table looks fine ... But Filter drop-downs are showing old data)??? How do I get the drop-downs to "Refresh"? ... Thanks ... Kha |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| slow document / pivot table refresh and pivot function | Excel Discussion (Misc queries) | |||
| Pivot table refresh | Excel Discussion (Misc queries) | |||
| Create refresh button in worksheet to refresh Pivot Table Data | Excel Worksheet Functions | |||
| Pivot Table refresh | Excel Discussion (Misc queries) | |||
| refresh a new worsheet on pivot table refresh | Excel Worksheet Functions | |||
Linear Mode
