A company uses a data-connected Microsoft Excel workbook to build reports from external data sources. Data is not refres

Business, Finance, Economics, Accounting, Operations Management, Computer Science, Electrical Engineering, Mechanical Engineering, Civil Engineering, Chemical Engineering, Algebra, Precalculus, Statistics and Probabilty, Advanced Math, Physics, Chemistry, Biology, Nursing, Psychology, Certifications, Tests, Prep, and more.
Post Reply
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

Post by answerhappygod »

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.
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!

This topic has 1 reply

You must be a registered member and logged in to view the replies in this topic.


Register Login
 
Post Reply