| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Remove old selections in Pivottable row field dropdown list
I am using a PivotTable to display data from an Access Database. As the data
changes I am unable to remove the old values in the row field dropdown lists. This list grows expoentially making navigation through the list difficult. Since I update the Pivot table via a macro, I am looking for a way to reset the row field dropdown list to only reflect the values in the data that is imported to the pivot table. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Remove old selections in Pivottable row field dropdown list
http://www.contextures.com/xlPivot04.html
Debra Dalgleish's site. -- Regards, Tom Ogilvy "Mark Purvis" <Mark wrote in message ... I am using a PivotTable to display data from an Access Database. As the data changes I am unable to remove the old values in the row field dropdown lists. This list grows expoentially making navigation through the list difficult. Since I update the Pivot table via a macro, I am looking for a way to reset the row field dropdown list to only reflect the values in the data that is imported to the pivot table. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I remove a Calculated Field from the Pivot Table field list | Excel Discussion (Misc queries) | |||
| counting dropdown list with multiple text selections | Excel Discussion (Misc queries) | |||
| PivotTable Field Value List Update | Excel Discussion (Misc queries) | |||
| Dropdown list in PivotTable has deleted items. How to omit? | Excel Discussion (Misc queries) | |||
| How do I refresh a PivotTable and remove outdated page field entr. | Excel Discussion (Misc queries) | |||
Linear Mode
