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.

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.