Sometimes, items continue to appear in a PivotTable item list even though the items no longer exist in the data. For example, you may have a field in the data that contains the names of salespersons. Over time, some of the salespersons have resigned, and new ones have been hired. The old salespersons' names may still appear in the field list, although the data no longer includes records for them, even after refreshing the data. These persistent items are called ghost items and in this tip, you will learn how to remove ghost items from your Excel PivotTables. …...more
...more
Show less