Field List in Pivot Table Not updating

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Ok, I have looked but can't find the answer I am looking for.

Background: There was a pivot table created which is linked to either a
sheet in the same workbook or I have also linked it to an external datasource
which has the same dataset layout and fields.

I have the need to create multiple sets of this pivot table and change the
actual dataset that it uses. I don't have any problems with this or with
refreshing the data.

The issue I am having is in the Pivot Table Field drop downs. Once there
data is refreshed the old values from the other data set are still present in
the dropdown and are actually hidden.

How do I get rid of these field values as a selection in the drop down for
the filtering?

Did I give enough information or do you need further clarification.

Thanks
Robert
 
The manual process didn't work, I had tried that already however, creating
the subroutine and doing it programatically worked like a charm.

THANK YOU!

Robert
 
You must log in or register to reply here.

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

How to clear data in pivot table? 4
Pivot Table Filters 2
Pivot Table Refresh Not Updating Drop Down List 1
Pivot Tables- SQL Alias' & Field Lists 1
Link Drop Down with Pivot Table 2
Sorting the pivot table field list 4
Pivot Table with Data Model Connection - getpivotdata reference issue 0
Pivot Table Defaults 1

Back
Top