• Article

Create PivotTable Dialog Box

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.

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