I created a dashboard (two charts) based on six pivot tables whose data is pulled from an Access database. There are dropdowns in the dashboard that are linked to the pivot tables using named ranges and formulas. I assigned a macro the the dropdowns that would update the data in the pivot tables according to what is selected in the dropdown. When I change the value in the dropdown I receive this run time error message.

I have some...