Pivot Table Refresh Not Updating Drop Down List

C

Caroline M

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top