Click the PivotTable report. Click the Options tab. Click the Change Data Source button Click the Select a table or range option, or click the Use an external data source and specify a connection.