![](/uploads/1/2/7/3/127347039/861716956.png)
![The connection program copy software The connection program copy software](/uploads/1/2/7/3/127347039/365799608.png)
![Program Program](/uploads/1/2/7/3/127347039/869954314.png)
Data in an Excel workbook can come from two different locations. The data may be stored directly in the workbook, or it may be stored in an external data source, such as a text file, a database, or an Online Analytical Processing (OLAP) cube. The external data source is connected to the workbook through a data connection, which is a set of information that describes how to locate, log in, query, and access the external data source.When you are connected to an external data source, you can also perform a refresh operation to retrieve the updated data. Each time that you refresh data, you see the most recent version of the data, including any changes that were made to the data since it was last refreshed.Connection information can either be stored in the workbook or in a connection file, such as an Office Data Connection (ODC) file (.odc) or a Universal Data Connection (UDC) file (.udcx).
Connection files are particularly useful for sharing connections on a consistent basis and for facilitating data source administration.If you use a connection file to connect to a data source, Excel copies the connection information from the connection file into the Excel workbook. When you make changes by using the Connection Properties dialog box, you are editing the data connection information that is stored in the current Excel workbook, and not the original data connection file that may have been used to create the connection, indicated by the file name that is displayed in the Connection File property.
Once you edit the connection information (with the exception of the Connection Name and Connection Description properties), the link to the connection file is removed and the Connection File property is cleared. The Workbook Connections dialog box helps you manage one or more connections to external data sources in your workbook. You can use this dialog box to do the following:.Create, edit, refresh, and delete connections that are in use in the workbook.Verify where external data is coming from, because, for example, the connection was defined by another user.Show where each connection is used in the current workbook.Diagnose an error message about connections to external data.Redirect a connection to a different server or data source, or replace the connection file for an existing connection.Display the Existing Connections dialog box to create new connections. For more information, see.Display the Connection Properties dialog box to modify data connection properties, edit queries, and change parameters. For more information, see.Make it easy to create and share connection files with users.To manage the connections in the current workbook, do one or more of the following:Identify a connectionIn the top portion of the dialog box, all connections in the workbook are displayed automatically with the following information:ColumnCommentNameThe name of the connection, defined in the Connection Properties dialog box.DescriptionAn optional description of the connection, defined in the Connection Properties dialog box.Last refreshedThe date and time that the connection was last successfully refreshed. If blank, then the connection has never been refreshed.Add a connection.Click Add to display the Existing Connections dialog box. For more information, see.Display connection information.Select a connection, and then click Properties to display the Connection Properties dialog box.
Thanking you everyday. It's Perks employees such as yourself that make our success possible. We want to express our appreciation for your ongoing commitment by bringing to you and yours this exciting member benefit filled with everyday discount offerings throughout the community and across the nation. Our hospital partners are the lifeblood of what we do. We take pride in our customer service and being there when you need us most. If we aren’t already, we’d love to be your community’s sole blood provider!
By using the Connection Properties dialog box or the Data Connection Wizard, you can use Excel to create an Office Data Connection (ODC) file (.odc).Do one of the following:.Create a new connection to the data source. For more information, see the following help topics:.Use an existing connection. For more information, see.Save the connection information to a connection file by clicking Export Connection File on the Definition tab of the Connection Properties dialog box to display the File Save dialog box, and then save the current connection information to an ODC file. For more information, see.
![](/uploads/1/2/7/3/127347039/861716956.png)