Skip to Content
Beginning SharePoint® 2007: Building Team Solutions with MOSS 2007
book

Beginning SharePoint® 2007: Building Team Solutions with MOSS 2007

by Amanda Murphy, Shane Perran
June 2007
Beginner
574 pages
15h 17m
English
Wrox
Content preview from Beginning SharePoint® 2007: Building Team Solutions with MOSS 2007

A.11. Chapter 11

A.11.1. Exercise 1 Solution

  1. Explain three benefits of using Excel Services for your organization's data reporting needs.

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.

A.11.2. Exercise 2 Solution

  1. True or False. When a workbook is published to a Reports Library, no one can change it.

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.

A.11.3. Exercise 3 Solution

  1. 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?

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 ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.

Read now

Unlock full access

More than 5,000 organizations count on O’Reilly

AirBnbBlueOriginElectronic ArtsHomeDepotNasdaqRakutenTata Consultancy Services

QuotationMarkO’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.
Julian F.
Head of Cybersecurity
QuotationMarkI wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.
Addison B.
Field Engineer
QuotationMarkI’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.
Amir M.
Data Platform Tech Lead
QuotationMarkI'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.
Mark W.
Embedded Software Engineer

You might also like

SharePoint® 2007 Collaboration For Dummies®

SharePoint® 2007 Collaboration For Dummies®

Greg Harvey
Microsoft® SharePoint® Foundation 2010 Inside Out

Microsoft® SharePoint® Foundation 2010 Inside Out

Penelope Coventry Errin O’Connor Troy Lanphier, Johnathan Lightfoot, Thomas Resing, and Michael Doyle

Publisher Resources

ISBN: 9780470124499Purchase book