MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

pivot table

  Asked By: Pedro    Date: Jan 13    Category: MS Office    Views: 1867

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.



1 Answer Found

Answer #1    Answered By: Freya Brown     Answered On: Jan 13
Didn't find what you were looking for? Find more on pivot table Or get search suggestion and latest updates.