2007 Microsoft® Office System Step by Step, Second Edition

Creating a Custom List from an Excel Workbook

Windows SharePoint Services 3.0 and Office SharePoint Server 2007 support larger, more versatile lists than previous versions of SharePoint. If you want to make information from an Excel worksheet conveniently available to team members as a SharePoint list, you don’t have to retype all the worksheet data into the list. You can create a custom SharePoint list by importing the worksheet contents, or a subset of it.

In this exercise, you will import data from an Excel workbook as a SharePoint list.

Note

USE the Marketing Team site you created earlier in this chapter, and the SalesData workbook. This practice file is located in the Documents\Microsoft Press\2007OfficeSBS\SharePoint folder.

1. Display the Marketing ...