External Data Source in Pivot Table
MS-EXCEL-84-Use of External Data Source in Pivot Table - Change Data Source - Connection Properties
How to Refresh Pivot Table? How to Change Data Source in Pivot Table? What are the Connection Properties in the Pivot Table? How to create pivot table from an external data source?