Create PivotTable Dialog Box

SQL Server 2012

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

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.