Share via

PivotTable.ShowPages Method

  • Article

Creates a new PivotTable report for each item in the page field. Each new report is created on a new worksheet.

Namespace:  Microsoft.Office.Interop.Excel
Assembly:  Microsoft.Office.Interop.Excel (in Microsoft.Office.Interop.Excel.dll)

Syntax

'Declaration
Function ShowPages ( _
    PageField As Object _
) As Object
'Usage
Dim instance As PivotTable
Dim PageField As Object
Dim returnValue As Object

returnValue = instance.ShowPages(PageField)

Object ShowPages(
    Object PageField
)

Parameters

  • PageField
    Type: System.Object

    Optional Object. A string that names a single page field in the report.

Return Value

Type: System.Object

Remarks

This method isn’t available for OLAP data sources.

See Also

Reference

PivotTable Interface

PivotTable Members

Microsoft.Office.Interop.Excel Namespace