Why in a pivot the "include new items in manual filter" option is grey out when source is a powerpivot?

1.5k views Asked by At

I have several pivots which source is a powerpivot, but the "include new items in manual filter" option in all my pivots are grey out.

1

There are 1 answers

1
Scopinho On BEST ANSWER

What version are you using? Ensure you didn't save the file as "compatible" version. If you have a file created/saved as older versions you need to save the file in one of the new file formats. The feature is not enabled with “Excel 2003 compatible” files for instance.