G
Guest
If I modify the origial data set to which a pivot table is pointing, deleting
data from the set, the deleted data still shows up in the pivot table pick
lists. For example, I have sales data for each month of the year, but delete
January through March. If I choose "Month" as a field in my Pivot Table, I
can still see the deleted months as options. However, there is no data
associated with them.
Is there a way to remove these deleted entries?
data from the set, the deleted data still shows up in the pivot table pick
lists. For example, I have sales data for each month of the year, but delete
January through March. If I choose "Month" as a field in my Pivot Table, I
can still see the deleted months as options. However, there is no data
associated with them.
Is there a way to remove these deleted entries?