AllowCustomOrdering Property

  • Article

This content is no longer actively maintained. It is provided as is, for anyone who may still be using these technologies, with no warranties or claims of accuracy with regard to the most recent product version or service release.

Returns or sets whether the user can reorder row axis or column axis members. Set this property to False to prevent users from row axis or column axis member reordering. The default value is True. Read/write Boolean.

expression.AllowCustomOrdering

expression   Required. An expression that returns a PivotTable object.

Example

This example prevents users from reordering members of the row axis or column axis in PivotTable1.

  PivotTable1.AllowCustomOrdering = False