Consolidating excel files

You can create Office Data Connection (ODC) files (.odc) by connecting to external data through the Select Data Source dialog box or by using the Data Connection Wizard to connect to new data sources.

An ODC file uses custom HTML and XML tags to store the connection information.

If you don't find the connection that you want, you can create a connection by clicking Browse for More to display the Select Data Source dialog box, and then clicking New Source to start the Data Connection Wizard.

If the external data source that you want to access is not on your local computer, you may need to contact the administrator of the database for a password, user permission, or other connection information.

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.

To ensure that the connection file is always used when a data source is refreshed, click Always attempt to use this file to refresh this data on the Definition tab.

If the data source is a database, make sure that the database is not opened in exclusive mode.

If the data source is a text file or a spreadsheet, make sure that another user does not have it open for exclusive access.