I have dynamic data that is summarized in Pivot Tables. Once refreshed the
old data is still in the dropdowns but not actually still in the data. Is
there a way to purge non-existant data from the dropdowns?
Thanks
Steve