Pivot table filter list not updating dating lava light

To fix this, you can change a pivot table setting, so the items with no data appear, along with the other items.

If you didn’t see your top pivot table annoyance in this list, there are other common problems, and their solutions (in most cases), on the Pivot Table FAQ page on my Contextures website.

Pivot table filter list not updating

Refresh Table Next I had the same problem and found a workaround - do not refresh entire workbook by clicking Refresh all, but refresh only data connection - this way your data will be up to date and your filtering won't be removed.

Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

If you remove or change data in the pivot table’s source, then refresh the pivot table, those old items might still appear in the drop down lists.

For example, after the Central region is merged with the East region, it still appears in the Region heading drop down, even though all the sales records were changed.

And for a list of all the pivot table tutorials and videos on my site, take a look at the Pivot Table Index page.

Here is a slide show that I made, summarizing the 5 Annoying Pivot Table Problems.

You can manually deselect the new items after they appear.

However, if you want to prevent the new dates from automatically appearing, you can change a setting in the pivot field, to specify if new items are included or not, when the field is manually filtered.

For example, if a product wasn’t sold in a specific city, that city doesn’t appear under the product heading.

Tags: , ,