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.
Select this option to create a new worksheet and start a new PivotTable on that 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.