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...