Why Does It Import Data So Easily From Other External Sources?

Excel for Microsoft 365 Excel 2021 Excel 2019 Excel 2016 Excel 2013 Excel 2010 Excel 2007 More than...Less

The master benefit of connecting to external data is that yous can periodically analyze this information in Microsoft Function Excel without repeatedly copying the data, which is an operation that can be time-consuming and mistake-decumbent. After connecting to external information, you tin can besides automatically refresh (or update) your Excel workbooks from the original data source whenever the data source is updated with new information.

To open the Existing Connections dialog box, select Data >Existing Connections. You tin brandish all the connections available to you lot and Excel tables in your workbook. Yous can open up a connection or table from the list and and so employ the Import Data dialog box to decide how y'all want to import the data.

The Existing Connectios dialog box in Excel displays a list of data sources currently in use in the workbook

Note:You can also open the Existing Connections dialog box from the Change PivotTable Information Source dialog box. For more information about changing the data source for a PivotTable, see Change the source data for a PivotTable.

In the Bear witness drib-down list, exercise i of the following:

All    To display all connections, click All Connections. This is selected by default.

Workbook   To display simply the recently used listing of connections, click Connections in this Workbook.

This list is created from connections that you lot have already divers, that you lot accept created past using the Select Data Source dialog box of the Data Connection Wizard, or that you lot have previously selected as a connectedness from this dialog box.

Computer   To display only the connections that are available on your computer, selectConnection files on this calculator.

This list is created from the My Data Sources folder that is usually stored in the My Documents folder on your computer.

Network   To display simply the connections that are bachelor from a connection file that is accessible from the network, selectConnection files on the Network. This list is created from an Excel Data Connexion Library (DCL) on a Microsoft SharePoint Services site. A DCL is a document library in a SharePoint Services site that contains a collection of Function Information Connexion (ODC) files (.odc). Typically, a DCL is ready by a site administrator, who can also configure the SharePoint site to display ODC files from this DCL in the External Connections dialog box. For more than information, run across SharePoint Services Central Assistants Assistance.
Select the connection that you desire, and then selectOpen. The Import Data dialog box appears.
Decide how you want to import the information, and then select OK. For more data about using this dialog box, select the question mark (?).

Tip:If you practice not come across the connection that you lot want, yous tin can create a connection. Click Browse for More than, and and then in the Select Data Source dialog box, click New Source to starting time the Data Connectedness Magician so that you can select the data source that you want to connect to.

Note:If you lot choose a connectedness from the Connectedness files on the network or Connection files on this computer categories, the connection file is copied into the workbook every bit a new workbook connection, and is then used equally the new connectedness information.

In the Show drop-down list, exercise ane of the following:

All   To display all connections, click Workbook Tables. This is selected past default.

Connections    To display tables defined just by a connection selectConnections Tables.

This list is created from connections that you take already defined, that you have created by using the Select Data Source dialog box of the Information Connection Sorcerer, or that y'all have previously selected as a connection from this dialog box.

Workbook    To display a tabular array in the workbook selectWorkbook Tables.
Select the connection that you want, so selectOpen. The Import Data dialog box appears.
Make up one's mind how you want to import the data, so select OK. For more than information about using this dialog box, select the question mark (?).