If you want to place the PivotTable on an existing worksheet, type or select the cell reference for only for the upper-left cell of the range where you want the PivotTable to appear.If your PivotTable is based on external data, your query will run to retrieve the data when you click Finish. Unless you've specified otherwise, the query runs in the background so that you can keep working while it retrieves the data.Do you want more information?
If you want to be asked each time you open a workbook whether to open it as read-only, choose Save As from the File menu, ...
If you want to define your own custom sort order, click Preferences on the Edit menu, and then click the Custom Lists tab. ...
If you want to freeze a row at the top of the window, select the row below it, and then choose Freeze Panes from the Window ...
If you want to permanently change the source file of a link, choose Links from the Edit menu, select the link in the list, ...
If you want to place the PivotTable on an existing worksheet, type or select the cell reference for only for the upper-left ...
If you want to print the worksheet with gridlines, choose Page Setup from the File menu and select the Gridlines check box ...
If you want to print the worksheet without gridlines, choose Page Setup from the File menu and clear the Gridlines check ...
If you want to reapply your number format when data is pivoted or refreshed, select the data field in the PivotTable, choose ...
If you want to search only within a certain range of cells for a specific value, select the range before you choose Find. ...