Exercises

1.	Explain three benefits to using Excel Services for your organization’s data reporting needs.
2.	True or False. When a workbook is published to a Reports Library, no one can change it.
3.	Your manager informs you that whenever team members access the newly created Dashboard, they receive an access denied error message and cannot see the individual reports. What’s the likely cause for this?

Answers

1.	Three key benefits of using Excel Services for your organization’s reporting needs include: Providing a centralized repository for reports rather than having them confined to individual hard drives or dispersed across many file-share folders or network locations. Rendering reports through the browser to display the data in a controlled setting and hiding any information related to formulas, calculations, or connections. Because Excel Services is built upon SharePoint technologies, all the standard benefits of working with SharePoint still exist such as versioning, item-level security, and content type management.
2.	False. You can assign users rights to edit or contribute to files. However, a key benefit of the Reports Library is that you can limit access to View or Read-Only for those who do not need edit access.
3.	First, you need to make sure that users have access to the site and its data. You then want to check that the site’s Reports Library and data connection libraries are configured as trusted locations within the SharePoint farm environment. You can do this by visiting the Excel Services Settings section of the Shared Services Administration site.