Pivot Table help

  • Thread starter Thread starter mikeg22
  • Start date Start date
M

mikeg22

I have set up a pivottable that relies on data in another worksheet
When I put new data in to the data worksheet, the field's old value
stay in the filter dropdown list on the pivottable. I want to know ho
to clear these values out so that only values that exist in the dat
are available to filter on.

Help please :
 

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

Pivot Table Page Field value from cell in another worksheet 3
Pivot Table operation is different 1
Pivot Table Change Macro 1
View Pivot Table Source data as a Data Table 6
Pivot Refresh Error when calling Excel Macro from VB.NET program 0
Hide Pivot Table Filters 1
Single Filter to change all Pivot Tables in a Workbook 8
Filter PivotTable dropdown items to match report filter 1

Back
Top