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?