ExcelBanter - pivot tables value filter

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - pivot tables value filter (https://www.excelbanter.com/excel-discussion-misc-queries/233426-pivot-tables-value-filter.html)

Tim

pivot tables value filter

I recently upgrade to excel 2007. The "allow multiple filter per field"
option is greyed out on a pivot table created in the prior version. How can
I activate that option?

Roger Govier[_3_]

pivot tables value filter

Hi Tim

Save the file as an XL2007 file (either xlsx or xlsm if it has macros).
Close then re-open.

--
Regards
Roger Govier

"Tim" wrote in message
...
I recently upgrade to excel 2007. The "allow multiple filter per field"
option is greyed out on a pivot table created in the prior version. How
can
I activate that option?

All times are GMT +1. The time now is 09:53 AM.