Export (0) Print
Expand All

Create PivotTable Dialog Box

Looking for help with Power Pivot in Excel 2013? Go to Power Pivot Help on Office.com.

The Create PivotTable dialog box enables you to specify the location for a new PivotTable that is based on PowerPivot data. The PivotTable is created in the Excel window. To access this dialog box, in the Excel window, on the PowerPivot tab, in the Reports group, click PivotTable. For more information about PivotTables, see Create a PivotTable or PivotChart Report.

New worksheet

Select this option to create a new worksheet and start a new PivotTable on that worksheet.

Existing worksheet

Select this option to use an existing worksheet. The default is to use the currently selected worksheet.


Click to navigate to an existing sheet and, optionally, a cell within that sheet.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

© 2015 Microsoft