Hi all,
If you open the attached file, don't update the workbook, I didn't attached the linked file. Do look under the "Opponent" column in the pivot table. For the last couple of years, there have been two items: 1 for "New York Jets" and another for "NewYork Jets". I have since combed the data and adjusted the "NewYork Jets" entry to add the space. I can't seem to get the item off of the filtered items however. In the past, I could live with it, but this year, the "St. Louis" item is changing to "Los Angeles", and I feel this issue will need addressing.
Does anyone know how to get items in the pivot table filtering lists to either: Update to be in line with the data, or let me edit the choices so that I can manually remove the ones that no longer exists?
Bookmarks