For years I have been filtering multiple pivot tables in a worksheet with the same field names but different data sources, arranged vertically, by applying column filters. I now have that working for some worksheets in a workbook, but in other worksheets, if the range to which I want to apply a filter includes part or all of a pivot table, the column filter icon is greyed out and I am unable to apply the filter. I cannot see what is different between those sheets and the sheets where it works.