I know this isn't a VBA question but we have a vast ocean of excel
talent here that I wanted to tap.



Does anyone know how to get rid of entries in a pivot table dropdown
sort box? (I bet that is confusing). I have a pivot table that I
refreshed and then I deleted a lot of the source data, but when I
refresh the table again there are still entries in the sorting dropdown
boxes from the old data that is no longer there. Can I get rid of that
without making a whole new table? I have done that before and it was a
pain and I am hoping just to delete the entries I don't need.