Page 1 of 15PREVNEXT

Lists II: Publish Excel 2003 lists to a SharePoint site

Publish Excel lists to your SharePoint site
In Microsoft Office Excel 2003, you can share list data with others by publishing the list to a Web site based on Microsoft Windows® SharePoint® Services. Once the list is published, you can update it from Excel, and others who have the permissions can add or revise list data from the SharePoint site. Take this course to learn how.

About this course

This course includes:

  • Two self-paced lessons and two practice sessions for hands-on experience.
  • A short test at the end of each lesson; tests are not scored.
  • A Quick Reference Card you can take away from the course.


After completing this course, you will be able to:

  • Publish a list from Excel to a SharePoint site.
  • Synchronize the lists when updates are made.
  • Resolve conflicts when different changes are made to the same data.

Before you begin

You should already be familiar with how to use the new list feature in Excel 2003, or you should complete the course Lists I: How to use lists in Excel 2003.

To do the practice sessions in this course, you must have access to a Web site based on Microsoft Windows® SharePoint® Services (a SharePoint site), and you must have permissions to create a list on the server. If you're not sure about whether you have these things, ask your systems administrator.

If you don't have a server running Windows SharePoint Services but if you do have Internet access, you can sign up for the Windows SharePoint Services Trial which will allow you do the practices. The trial will allow you to try out SharePoint for a month without having to set up your own Windows Server environment.

In this course you'll learn how to publish an Excel list to a SharePoint site. Then you'll learn how to synchronize the Excel list so that when you make changes to it the SharePoint list gets updated at the same time.

You'll also learn how to resolve conflicts when different changes are made to the same data in Excel and in the SharePoint list.

To learn more about this course, read the overview information or the table of contents in the left column. When you're done reading this page, click Next to start the first lesson.

Page 1 of 15PREVNEXT