Information
The topic you requested is included in another documentation set. For convenience, it's displayed below. Choose Switch to see the topic in its original location.

CubeField.IncludeNewItemsInFilter Property

Office 2007
The IncludeNewItemsInFilter property is used to track included/excluded items in OLAP PivotTables. Read/write.

Version Information
 Version Added:  Excel 2007

Syntax

expression.IncludeNewItemsInFilter

expression   A variable that represents a CubeField object.

Remarks

Default value is False.

When this setting is set to True, excluded items are tracked when manual filtering is applied. When this setting is set to False, included items are tracked when manual filtering is applied.

When IncludeNewItemsInFilter is set to False, the HiddenItemsList and HiddenItems collections are empty and items cannot be added to them.

When IncludeNewItemsInFilter is set to True, the VisibleItemsList and VisibleItems collections are empty and items cannot be added to them.




Community Additions

Show:
© 2014 Microsoft