A company uses a data-connected Microsoft Excel workbook to build reports from external data sources.
Data is not refreshed when the workbook is displayed in a browser.
You need to ensure that users can refresh Excel workbooks that are displayed in a browser.
Which two actions should you perform? (Each correct answer presents a complete solution. Choose two.)
A.
Configure the Secure Store service application for the Excel workbook.
B.
Embed the data connection information directly in the Excel workbook.
C.
Create a trusted data connection library and add a data connection file.
D.
Add the document library containing the Excel workbook to the Trusted File Locations list.
E.
Create a Group Policy Object that adds the SharePoint URL to the Trusted Sites zone in Windows Internet
Explorer.
Explanation:
To configure Excel Services data access to use embedded data connections, you use the following process:
Configure a data access account
(A) Create a Secure Store target application
(B) Configure a workbook to use an embedded data connection
A: You must create a target application in Secure Store that contains the credentials that you created for data
access. This target application can then be specified in data-connected Excel workbooks and will be used by
Excel Services when it refreshes data in the workbook.
B: Configure a workbook to use an embedded data connection
You must configure the Excel Services Authentication Settings in the workbook before you publish it to
SharePoint Server 2013. Doing so enables the workbook to use a Secure Store target application to refresh
data that is rendered using Excel Services. Use the following procedure to configure the authentication settings.
Note:
* Excel Services in SharePoint Server 2013 provides three methods of using Secure Store Service to refresh
the external data source in a workbook:
/ You can use an unattended service account.
/ You can specify a Secure Store target application in a workbook. (This is known as an embedded connection.)
/ You can use an Office Data Connection (ODC) file that specifies a Secure Store target application. This article
describes how to do this.
Configure Excel Services data refresh by using external data connections in SharePoint Server
2013