HDTutorial
EN
How to Remove Old Items from Pivot Table Drop Downs in Excel

Playback starts YouTube’s embedded player (privacy-enhanced mode).

How to Remove Old Items from Pivot Table Drop Downs in Excel

63,700 views November 1, 2012 1:55

Watch on YouTube
ChannelContextures Inc.

Description from the creator

After you create an Excel pivot table, the source data may change. Items that were previously in the source are no longer included.

In this example, two regions are merged, and the Central region name is no longer in the source data.

When you refresh the pivot table, the Central region data disappears, but its name is still in the Region drop down.

This video shows how you can clear the old Region name, and prevent old items from appearing in the future.

This pivot table setting is available in Excel 2007 and later.

To get the Excel workbook, go to the Clear Old Items page on my Contextures site.
contextures.com/xlPivot04.html

About this tutorial

Contextures Inc. published this 1:55 video tutorial on November 1, 2012. It has been watched 63,700 times on YouTube.

Duration
1:55
Published
November 1, 2012
Views
63,700
Likes
337

Tags

Share

This tutorial in other languages