Macro Sheets Only
Creates new sheets in the workbook containing the active cell. The function will iterate through each item in page_field and create a new PivotTable on a new sheet with the page field set to that particular item.
Syntax
PIVOT.SHOW.PAGES(name, page_field)
Name is the name of the target PivotTable. If name is omitted, Microsoft Excel will use the PivotTable containing the active cell.
Page_field is the name of a page field in the PivotTable specified by the name argument.
Remarks
If the function is successful, it returns TRUE; otherwise, it returns the #VALUE! error value.
If name is not a valid PivotTable name then the #VALUE! error value is returned.
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.ITEM.PROPERTIES Changes the properties of an item within a header field
PIVOT.REFRESH Refreshes a PivotTable
PIVOT.TABLE.WIZARD Creates an empty PivotTable
List of Command-Equivalent Functions