Pivot table filter list not updating
Visit Stack Exchange I have a Pivot Table and the source is a Table (not a range of cells).When I modify the source table, in the Pivot Table Filter I see both old and modified item.For example, if a product wasn’t sold in a specific city, that city doesn’t appear under the product heading.To keep the layout consistent, you might want to see all the items, in each section.When you update the pivot table, the new dates might appear, even if you hadn’t selected those dates in the manual filter.Seeing the new dates could be helpful, if you want to make sure that you notice new records when they’re added.
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.
For example, in one column I have street names and I change as below: Old: Heidelberger St.
Modified to: Heidelberger Street Now, in the Pivot Table (after doing Refresh All), when I open the header filter, I see both "Heidelberger St." and "Heidelberger Street".
When you add new records to the pivot table’s source data, then refresh the pivot table, you expect to see all the new data. To fix this, make sure that the source data is in a dynamic range, that will grow and shrink automatically, when data is added or removed.
If you put two or more fields in the Row area, all the items might not appear in each section.