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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top