Mega Code Archive
Select a different data source for a PivotTable
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.