automatically add new items to a pivot table's filter

[Rowland Hamilton]

Folks:

Hopefully an easy one for you. I hear there is a menu option to automatically add (check mark) new items to a pivot table's filter. How do I select this? I'm using MS Excel 2010. My end users want to be able to have all filters, existing and new, be able to accept all new items (as checked, do not filter out).

FYI: I forced my existing filter to accept "#N/A"'s when they appear by checking the box when I had an "#N/A."

Captain Obvious: the filter still has to be able to filter out the known unwanted data (currently unchecked in filter drop down).

ex. Filtering out (unckecked) "Cat" and filtering in (checked) "Dog". Now if "Bird" appears in the category for the first time, I want excel to filter that in (checked) but, currently, my pivot table will filter it out (unchecked).

Thank you, Rowland

 

[Rowland Hamilton]

Okay, so I found that when you click "Field Settings" for your pivot table field, there is a check box for "Include New Items In Your Manual Filter." Don't know if there is an automatic setting for all fields setting, but, if not, this will have to do.
Just had to google search "pivot table filter" and "new items"

Answer was on: http://www.facebook.com/note.php?note_id=10150158854076920

Thank you - Rowland