Excel Services IV: Allow user input

A conceptual image of entering data in Excel Services

Allow people to enter data for selected cells when you use Excel Services to publish an Excel 2007 spreadsheet to your Microsoft Office 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:

  • Allow people to do calculations in Excel Services.

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 your computer, which is included in all the following: Office Professional Plus 2007, Office Enterprise 2007, or Office Ultimate 2007.

Topics in this course

  1. Allow people to do calculations in Excel Services

  2. Step 1: Check for cell names

  3. Step 2: Name cells for Excel Services

  4. Step 3: Enable data entry in Excel Services

  5. Step 4: Enter values in Excel Services

  6. Quick reference card

Applies To: SharePoint Server 2007, Excel 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!

Change language