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
🙂