Click anywhere within the table range.
Click the Insert tab.
Click the PivotTable button arrow and then click PivotTable, or PivotChart.
Click the Select a table or range option,
or click the Use an external data source option,
click Choose Connection, and then select a connection.
Click the New worksheet option or Existing worksheet option,
and specify a cell range.
Click OK.
Select the check boxes next to the fields you want to use to add them to the empty PivotTable.