pivot tables value filter

T

Tim

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?
 
R

Roger Govier

Hi Tim

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