Old data appearing in Drop Down list in Pivot Table field

C

cbriscoe

I have a Pivot that I run with External Data through MS Query for
Postal Codes - when I change the query to report a different postal
code, the old code previously reported still shows up in the drop down
list in the Pivot Table filed. There is no data attached to the old
Postal Code, but I would prefer that they don't show up on the list at
all. Is there any way to clear the memory of the old report?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Drop down lists in seperate columns 5
Drop down list control value in vba 2
Trying to create a report that will list unmatched records by Ticket Primary Key 0
Word VBA - Auto Populate Text on Dependent Drop Down Exit 1
Excel 2013 Pivot Data Range formula reference problem 0
Link Drop Down list with Pivot Table 3
Link Drop Down with Pivot Table 2
Link Drop Down list with PIVOT Table in Excel 2003 0

Top