AutoLayout Method

         Example         Applies To

Resets the specified PivotTable list to a default view configuration.

Syntax

expression.AutoLayout(MaxDataFields)

expression   An expression that returns a PivotView object.

MaxDataFields   Optional Long. Specifies the maximum number of fields that can be addedto the data axis if the data member is a recordset. If this argument is not specified or is zero (0), there is no limit to the number of fields that will be added.

Remarks

If the PivotTable list is bound to a recordset, a field set is added to the data axis for each field in the recordset.

If the provider is multidimensional, all field sets are removed from the axes. This completely clears the current view.