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?
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?
There are instructions here for clearing old items from a pivot table:
http://www.contextures.com/xlPivot04.html
Bonny wrote:
> 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?
--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks