I have turned number of items to retain field to none and also tried the VBA macro in the link below. Neither worked and when I refresh my pivot table the filter still keeps items not being used. The only solution is to completely rebuild the pivot table but what’s the point if the filter will keep those items when I try to use the pivot table again later.
https://www.extendoffice.com/documents/excel/4238-excel-clear-filter-cache.html
