From: Jen_T on
I was wondering if there is an easy way to locate a specific field in the
pivot field list in Excel 2007 without having to scroll the list of fields
and find the one you are looking for if you have many? I know in 2003 you
were able to start typeing the word or numeric and it would find the first
match as you typed.
From: Herbert Seidenberg on
Excel 2007 PivotTable
Expanded, auto-complete
PivotItem drop-down list in RowField.
With macro.
http://c0718892.cdn.cloudfiles.rackspacecloud.com/04_14_10.xlsm
Pdf preview:
http://www.mediafire.com/file/mewgzmiwzyd/04_14_10.pdf