How do I remove "old" drop-down menu items in pivot table?
I am pulling from a database. We used to have a northeast region, now it is no longer but it still remains in my pivot table in the region field drop down. How can I get rid of this? I have many more cases where this happens and need a solution other than re-create the pivot. Please help!