Connecting to an external data source


show more Connecting to an external data source provides you with in-depth training on Business. Taught by Curt Frye as part of the Excel 2010: Pivot Tables in Depth show less
please wait ...

Connecting to an external data source

Excel enables you to build PivotTables from data found both inside and outside the workbook where you create the PivotTable. If you want to create a PivotTable from a data source you either can't or don't want to import into Excel directly, you can create a connection to that data source and work with it in place. So let's say that you want to create a PivotTable using data from another Excel workbook. To do that, you go to the Insert tab and click the PivotTable button. Then in the Create PivotTable dialog box you select the Use an external data source option and then click Choose Connection.

Then in the Existing Connections dialog box, if the connection or the data source that you want already appears, then you can click it and then click Open. In this case, I haven't created any connections yet so I will click the Browse for More button and this displays a version of the Open dialog box. In this case, it's named Select Data Source. The data that I want is in my Exerc...

Connecting to an external data source
Video duration: 3m 30s 3h 43m Intermediate

Viewers:

Connecting to an external data source provides you with in-depth training on Business. Taught by Curt Frye as part of the Excel 2010: Pivot Tables in Depth

Subject:
Business
Software:
Excel
Author:
please wait ...