How to reset Filter after updating pivot from external data?

H

helpnexcel

After I update a pivot table from external data, my filters are out of
whack. For example, if I change the criteria to pull from - after the
update it still shows records previously that no longer are
represented. In addition, additional values that are populated just
shoot to the bottom of the filter instead of working into the sort
alphabetically like the original update.

I would like to know how I can update the filter along with the data so
it only shows valid availalbe data, sorted correctly.

Thanks!
 

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

Filter Help with Pivots - External Data 1
date filter in a pivot table 1
XL2007: Pivot table date filter 1
Single Filter to change all Pivot Tables in a Workbook 8
pivot table and critera range filter 1
Creating auto Updating Pivot Table linked to external data. 1
Filter drop down box in pivot table 1
Storing Multiple Selected Pivot Table Report Filter Values 2

Top