Members of the Sales team store Microsoft Excel workbooks and other files on a SharePoint team site. The workbooks do not access external data. When Sales team members attempt to open workbooks from the team site, they receive an error message stating that the workbook cannot be opened. You need to configure the SharePoint farm to ensure that users can open Excel workbooks. What should you do?

Question

Accepted Answer

A. Set Trusted File Locations for Excel Services. Excel Services in SharePoint 2013 requires all file locations from which it renders workbooks to be explicitly listed as Trusted File Locations in the Excel Services service application settings. Without this configuration, Excel Services rejects requests to open workbooks regardless of user permissions. Adding the SharePoint team site URL as a trusted location resolves the error and allows workbooks to be opened in the browser.

Answer

B. Add members to a Secure Store target application. Secure Store target applications are used to map credentials for external data connections, which is irrelevant here because the workbooks do not access external data.

Answer

C. Set the Excel Calculation Services authentication method to Impersonation. The Impersonation authentication method in Excel Calculation Services is used when workbooks access external data sources under user credentials, which does not apply since no external data is involved.

Answer

D. Grant members Read permission to the Sales team site. Granting Read permission to the SharePoint site addresses document library access but does not resolve Excel Services configuration errors caused by missing Trusted File Locations.

Members of the Sales team store Microsoft Excel workbooks and other files on a SharePoint team site. The workbooks do not access external data. When Sales team members attempt to open workbooks from…

Question

Options

How the community answered

Why each option

Topics

Community Discussion