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

Share Facebook Facebook Twitter Twitter Email Email

Was this information helpful?

Great! Any other feedback?

How can we improve it?

Thank you for your feedback!