Updating and refreshing PivotTable data sources

Companies generate new sales, budget, and operations data all the time.…So PivotTable data sources rarely remain static.…In this movie I'll show you how to manage your data connection to ensure your…PivotTable contains the most recent data available.…You can display your PivotTable's data connection by clicking any cell in the…PivotTable, as I've done here, and then on the Options contextual tab click the…Change Data Source button.…When you do, the Change PivotTable Data Source dialog box appears and in this…case you can see that this PivotTable draws its data from a table with the name of Firm Data.…

If you want to change the data source you can select a new data source…within the Workbook.…But notice that the Use an external data source option is grayed out.…The reason that's the case is because you can change a data source to another…one of the same kind.…That is, you can swap one internal data source for another or one external data…source for another but you can't change from one type of connection to another.…