Which two actions should you perform?

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.

microsoft-exams

Leave a Reply

Your email address will not be published. Required fields are marked *


The reCAPTCHA verification period has expired. Please reload the page.