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.