Create odc file excel

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. It replaced the Workbook Connections dialog box which is available in Excel stand-alone versions , , and This pane has two tabs:.

Queries Displays all the queries in the workbook. Right click a query to see available commands. For more information, see Manage queries. Connections Displays all the connections in the workbook. Right click a connection to see available commands. For more information, see Connection properties. Verify where external data is coming from, because, for example, the connection was defined by another user. 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. Display the Connection Properties dialog box to modify data connection properties, edit queries, and change parameters. 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. If blank, then the connection has never been refreshed.

Click Add to display the Existing Connections dialog box. Select a connection, and then click Properties to display the Connection Properties dialog box. 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. Another advantage of. Excel Services can only open. For additional information please see White paper: Excel Services step-by-step guides and Plan external data connections for Excel Services.

It is desirable to provide users with an easy means of accessing these. This can be done by adding the data connection library to the navigation links. If the checkbox is not checked, then an embedded data connection would be created instead.

The next step is to upload the. For example,.. Click OK. Web Parts Overview. Business Overview Web Part. Skip to main content. This browser is no longer supported. Download Microsoft Edge More info. Need more help? Expand your skills. Get new features first. Was this information helpful? Yes No. Thank you! Any more feedback? The more you tell us the more we can help. Can you help us improve? Resolved my issue. Clear instructions.