O'Reilly logo

2007 Microsoft® Office System Step by Step, Second Edition by Joan Lambert, John Pierce, Steve Lambert, M. Dow Lambert III, Curtis D. Frye, Joyce Cox

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required