i'm sure this is just a setting somewhere, but i'm having trouble finding it. when i'm in a pivot table, and adjusting the report filter, a drop-down list with all my options appear. i remember when working on other versions of excel there was a search box at the top of this drop-down box. i would be able to type in a portion of what i was looking for, and return only the fields that have what i typed in. the version i'm working on now does not have that "search box".
any help on how i might be able to turn on that setting? much appreciated.
Bookmarks