Excel.PivotTable.ShowPages.md

title	keywords	f1_keywords	api_name	ms.assetid	ms.date	ms.localizationpriority
PivotTable.ShowPages method (Excel)	vbaxl10.chm235077	vbaxl10.chm235077	Excel.PivotTable.ShowPages	7ebb55ab-ecda-31f7-23d2-fdefc12ee161	05/09/2019	medium

PivotTable.ShowPages method (Excel)

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

Syntax

expression.ShowPages (PageField)

expression A variable that represents a PivotTable object.

Parameters

Name	Required/Optional	Data type	Description
PageField	Optional	Variant	A string that names a single page field in the report.

Return value

Variant

Remarks

This method isn't available for OLAP data sources.

Example

This example creates a new PivotTable report for each item in the page field (the field named Country).

Set pvtTable = Worksheets("Sheet1").Range("A3").PivotTable 
pvtTable.ShowPages "Country"

[!includeSupport and feedback]