Dropdown list in PivotTable has deleted items. How to omit?

G

Guest

I deleted rows from my source data for a PivotTable, but when I refreshed the
PivotTable, the dropdown list for that field still contains "ghost" items
that were deleted. How do I get rid of them?
 

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

Similar Threads

Filter PivotTable dropdown items to match report filter 1
The PivotTable field name is not valid (error) 1
Pivot table - problem with field 4
Difference column in PivotTable 1
Finding unique items in data field for pivot tables 2
Pivottable code problem 4
Excel 2007 - The connection for this PivotTable has been deleted 1
PivotTable Question 6

Top