Remove old selections in Pivottable row field dropdown list

G

Guest

I am using a PivotTable to display data from an Access Database. As the data
changes I am unable to remove the old values in the row field dropdown lists.
This list grows expoentially making navigation through the list difficult.
Since I update the Pivot table via a macro, I am looking for a way to reset
the row field dropdown list to only reflect the values in the data that is
imported to the pivot table.
 

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

Remove all column and row fields from a pivot table 1
Pivot Tables - using .AutoShow 1
dropdown menu accross row data as list fill range 1
The PivotTable field name is not valid (error) 1
Pivot Table Page Fields Selection 1
Pivot macro problem 2
Automatically Update a Pivot Table Field Used as Column / Row 1
linking pivot table selections 2

Top