To stop the current refresh operation, click Cancel Refresh.įor more information, see Refresh an external data connection in Excel. To get status information about a refresh operation, select one or more connections, and then click Refresh Status. To refresh all connections in the workbook, clear all connections, and then click Refresh All.
To refresh specific connections, select one or more connections, and then click Refresh. For more information, see Connection properties.Ĭlick the arrow next to Refresh, and then do one of the following: Select a connection, and then click Properties to display the Connection Properties dialog box. For more information, see Connect to (Import) external data. If blank, then the connection has never been refreshed.Ĭlick Add to display the Existing Connections dialog box. The date and time that the connection was last successfully refreshed. The name of the connection, defined in the Connection Properties dialog box.Īn optional description of the connection, defined in the Connection Properties dialog box. In the top portion of the dialog box, all connections in the workbook are displayed automatically with the following information: To manage the connections in the current workbook, do one or more of the following: Make it easy to create and share connection files with users. For more information, see Connection properties. For more information, see Connect to (Import) external data.ĭisplay the Connection Properties dialog box to modify data connection properties, edit queries, and change parameters. Redirect a connection to a different server or data source, or replace the connection file for an existing connection.ĭisplay the Existing Connections dialog box to create new connections. Show where each connection is used in the current workbook.ĭiagnose an error message about connections to external data. Verify where external data is coming from, because, for example, the connection was defined by another user. You can use this dialog box to do the following:Ĭreate, edit, refresh, and delete connections that are in use in the workbook. The Workbook Connections dialog box (Select Data > Connections) helps you manage one or more connections to external data sources in your workbook. Note The Workbook Connections dialog box is available in Excel stand-alone versions 2010, 2013, and 2016, but was replaced in Microsoft Office 365 for Excel and Excel stand-alone version 2019 with the Queries & Connections pane. 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. 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.
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. Connection files are particularly useful for sharing connections on a consistent basis and for facilitating data source administration. 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.Ĭonnection 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). When you are connected to an external data source, you can also perform a refresh operation to retrieve the updated data.
EXCEL QUERY TABLE CHANGE CONNECTION HOW TO
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. 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. Data in an Excel workbook can come from two different locations.