Use of External Data Source in Pivot Table

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?