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.Location
Click to navigate to an existing sheet and, optionally, a cell within that sheet.