![excel online excel online](https://i.ytimg.com/vi/fdWcaanB0iQ/maxresdefault.jpg)
This can be an Active Directory account, a SQL Server logon, or other set of credentials as required by your data source. You must have an account that can be granted access to the data source to which you want to connect your Excel workbook. Using Excel Online with an ODC file consists of the following steps:Ĭonfigure an Excel workbook to use the published ODC file as a data connection
![excel online excel online](https://www.mini-kurzy.cz/wordpress/wp-content/uploads/2014/05/excel2007_homepage.jpg)
To use an ODC file, you must also configure server-to-server authentication between Office Online Server and SharePoint Server. This allows you to share a single ODC file among multiple workbooks and also allows you to centrally manage your data connections.īefore you can use Excel Online with an ODC file, you must have installed Office Online Server and configured it to work with SharePoint Server.
EXCEL ONLINE HOW TO
This article describes how to do this.īy using an ODC file for your data connection, you separate your Excel workbooks from the data connection information. You can use an Office Data Connection (ODC) file that specifies a Secure Store target application. (This is known as an embedded connection.) For more information, see Configure Excel Online data refresh by using embedded data connections in Office Online Server. You can specify a Secure Store target application in a workbook. Summary: Configure Excel Online data refresh by using Secure Store and an external Office Data Connection (ODC) file.Įxcel Online provides two methods of using Secure Store Service to refresh the external data source in a workbook: