Pivot Table Refresh Not Updating Drop Down List
I have data and a corresponding pivot table in separate worksheets. The data
in the worksheet has been updated by deleting a row mid table. The pivot table has been refreshed. When I look at the pivot table on the worksheet the refresh appears to have worked because the deleted data is not on the pivot table worksheet at all. When I selecte the drop down however, the deleted data is still a selectable item. Selecting it returns nothing. I've done an extended search through the entire spreadsheet and the deleted data does not appear anywhere else, other than the pivot table drop down. How can I refresh the drop down select box? Thank you. |
Pivot Table Refresh Not Updating Drop Down List
Think Debra covers this phenomena/correctives at her page:
http://www.contextures.com/xlPivot04.html Excel -- Pivot Tables -- Clear Old Items -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Caroline M" wrote: I have data and a corresponding pivot table in separate worksheets. The data in the worksheet has been updated by deleting a row mid table. The pivot table has been refreshed. When I look at the pivot table on the worksheet the refresh appears to have worked because the deleted data is not on the pivot table worksheet at all. When I selecte the drop down however, the deleted data is still a selectable item. Selecting it returns nothing. I've done an extended search through the entire spreadsheet and the deleted data does not appear anywhere else, other than the pivot table drop down. How can I refresh the drop down select box? Thank you. |
All times are GMT +1. The time now is 06:49 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com