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.
A company uses a data-connected Microsoft Excel workbook to build reports from external data sources. Data is not refres
-
answerhappygod
- Site Admin
- Posts: 899604
- Joined: Mon Aug 02, 2021 8:13 am
A company uses a data-connected Microsoft Excel workbook to build reports from external data sources. Data is not refres
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!