PIVOT.ITEM.PROPERTIES

Macro Sheets Only

Changes the properties of an item within a header field.

Syntax

PIVOT.ITEM.PROPERTIES(name, pivot_field_name, pivot_item_name, new_name, position, show, active_page)

Name is the name of the PivotTable containing the item which the user wants to edit.

Pivot_field_name is the name of a field in the PivotTable containing the item which the user would like to edit. If it is omitted, Microsoft Excel uses the field containing the active cell.

Pivot_item_name is the name of the item which the user would like to edit. If it is omitted, Microsoft Excel uses the item containing the active cell.

New_name is the name which you would like to rename the current item. If it is omitted, then the name of the current item will not change.

Position is a number representing where in the field the item will appear. Position 1 is the topmost position within the row field, the leftmost position within the column field, and the highest position within the page field. If the position argument is omitted, it will default to the last position in the field.

Show is a logical value which if TRUE causes the item to appear in the PivotTable. If FALSE, the item will be hidden.

Active_page is a logical value specifying whether item_name will become the active item in the page field. If TRUE then item_name will become the active item in the page field. If FALSE or omitted, the active item in the page field does not change. Applies to only page fields.

Remarks

• If name is omitted, Microsoft Excel will use the PivotTable containing the active cell.
• If pivot_field_name is not a header field, then this function will return the #VALUE! error value.

Related Functions

PIVOT.ADD.DATA Adds a field to a PivotTable as a Data Field

PIVOT.ADD.FIELDS Adds fields to a PivotTable

PIVOT.FIELD Pivots fields within a PivotTable

PIVOT.FIELD.GROUP Creates groups within a PivotTable

PIVOT.FIELD.PROPERTIES Changes the properties of a field inside a PivotTable

PIVOT.FIELD.UNGROUP Ungroups all selected groups within a PivotTable

PIVOT.ITEM Moves an item within a PivotTable

PIVOT.REFRESH Refreshes a PivotTable

PIVOT.SHOW.PAGES Creates new sheets in the workbook containing the active cell

PIVOT.TABLE.WIZARD Creates an empty PivotTable

List of Command-Equivalent Functions