| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to refresh drop-down list of pivot table
We find that after a pivot table is created, the the drop-down list values of
filter in the table will not be refreshed as soon as the change of data. E.g, orginally in the pivot table there is a value A in the column, afterward in the data source value A is replaced by value B. But we can find that value A is still in the list of drop-down values. Is this a bug of Excel or there is some configuration of this? Is there any fix? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pivot Table Refresh Not Updating Drop Down List | Excel Worksheet Functions | |||
| Create refresh button in worksheet to refresh Pivot Table Data | Excel Worksheet Functions | |||
| Pivot Table - Duplicate values drop-down when I refresh data | Excel Discussion (Misc queries) | |||
| IS THERE ANY PIVOT TABLE DROP LIST FUNCTION? | Excel Worksheet Functions | |||
| Need help with Drop-Down list and Pivot Table | Excel Worksheet Functions | |||
Threaded Mode
