I have created a number of pivot tables based on a drop down box in my form. I am creating individual reports and filtering each one by the corresponding criteria. Like so:

• Report #1 - Leads (Drop down option = "Lead", Pivot table filter = "Lead"). The pivot table displays all open leads in the system.
  
  
• Report #2 - Prospects (Drop down option = "Prospect", Pivot table filter = "Prospect"). The pivot table displays all open prospects in the system.

And so on...

All of the pivot tables worked great until I added additional options to the drop down box. I would have expected that the filter options in the pivot table (Filters > Actual Values) to automatically update with the new choices I added to the dropdown. 

However, only the original options remain. 

Even when I create a brand new pivot table from scratch using the choices from the dropdown, the old filter options are the only choices I have available to me.

I think what I need is a system wide refresh for all of this data so that I can use them in my pivot tables.

How do I force refresh this data?