Excel Services III: Control what people see

A conceptual view of private data in an Excel spreadsheet.

Control what people can see when you use Excel Services to publish an Excel 2007 spreadsheet to your SharePoint Server 2007 Enterprise site.

Start course button

About this course

This course includes:

  • A Quick Reference Card you can take away from the course.


After completing this course you will be able to:

  • Display individual spreadsheets instead of an entire workbook on your SharePoint site that people can see in Excel Services by using a Web browser.

  • Display selected spreadsheet items, such as charts or PivotTable reports, instead of individual worksheets.

Before you begin

You should already know basic information about working with Excel Services. If not, you should take "Excel Services I: The basics."

Software requirements:

  • A SharePoint site based on SharePoint Server 2007 Enterprise.

  • Excel Services set up with SharePoint Server 2007 Enterprise.

  • Excel 2007 installed on computers through one of the following: Office Professional Plus 2007, Office Enterprise 2007, or Office Ultimate 2007.

Topics in this course

  1. Select what people can see in Excel Service

  2. Keep data private in Excel Services

  3. Select the worksheets you do not want people to see

  4. Select the workbook items you want people to see

  5. An important note

  6. Quick reference card

Applies To: Excel 2007, SharePoint Server 2007

Was this information helpful?

Yes No

How can we improve it?

255 characters remaining

To protect your privacy, please do not include contact information in your feedback. Review our privacy policy.

Thank you for your feedback!

Support resources

Change language