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.AllItemsVisible Property

Office 2007
The AllItemsVisible property checks whether manual filtering is applied to a PivotField or CubeField. Read-only Boolean.

Version Information
 Version Added:  Excel 2007

Syntax

expression.AllItemsVisible

expression   A variable that represents a CubeField object.

Remarks

Default value is True and is available for the PivotField and the CubeField objects.

For OLAP PivotTables, this property is only available for the CubeField object. Trying to get or set it on the PivotField object in OLAP PivotTables will return a run-time error.

For PivotTables, this property is available for the PivotField object.

This property is automatically set to True when no manual filtering is applied (independent of whether the IncludeNewItemsInFilter property is true or false). It is automatically set to False when any manual filtering is applied (independent of whether the IncludeNewItemsInFilter property is true or false).




Community Additions

Show:
© 2014 Microsoft