Clear Drop Down in Pivot Table (2003)

Topic

New Reply

Is there a way to eliminate old items in a drop down list from a pivot table that aren’t in use anymore?

Thanks!

Reply | Quote

Replies

I’m not sure what you mean, but does the code from post 219,148 do what you want? Test it on a copy of your workbook first!

Reply | Quote

Thanks very much Hans! That did the trick.

Reply | Quote