Before we start choosing data for the PivotTable, we need to change the connection to the SQL query. Make sure you are on the Options tab and click on Change Data Source drop down from the Data section. Choose Connection Properties.
This brings up the Connection Properties form. Click on the Definition tab. This shows you the connection information for the current connection to SQL Server. While it references a connection file, the data is actually embedded in the spreadsheet.