For more information, see Connection properties.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:In the top portion of the dialog box, all connections in the workbook are displayed automatically with the following information:The name of the connection, defined in the Connection Properties dialog box.An optional description of the connection, defined in the Connection Properties dialog box.The date and time that the connection was last successfully refreshed. For more information, see Connect to (Import) external data.Display the Connection Properties dialog box to modify data connection properties, edit queries, and change parameters. 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.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.The Workbook Connections dialog box (Select Data > Connections) 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. 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. 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.
For more information, see Connection properties.Click the arrow next to Refresh, and then do one of the following:To refresh specific connections, select one or more connections, and then click Refresh.To refresh all connections in the workbook, clear all connections, and then click Refresh All.To get status information about a refresh operation, select one or more connections, and then click Refresh Status.To stop the current refresh operation, click Cancel Refresh.For more information, see Refresh an external data connection in Excel.Select one or more connections to be removed from the workbook, and then click Remove. For more information, see Connect to (Import) external data.Select a connection, and then click Properties to display the Connection Properties dialog box.
0 kommentar(er)
