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 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 link to a specific location (anchor) within the file, enter the name of the anchor above or click Locate to ...
If you want to link to a specific location (anchor) within the Web page, enter the name of the anchor above or click Locate ...
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. ...