Chapter 12: Using Windows SharePoint Services with Excel 2007

 Download CD Content

Chapter at a Glance

Import data from an Excel 2007 spreadsheet, page 330. Use the Access Web Datasheet, page 333. Export an Excel 2007 table to a SharePoint list, page 344. Export a SharePoint list to an Excel 2007 spreadsheet, page 340.

In This Chapter, You will Learn to:

• Import data from a Microsoft Office Excel 2007 spreadsheet to a list in Microsoft Windows SharePoint Services.

• Use the Access Web Datasheet.

• Export a SharePoint list to an Office Excel 2007 spreadsheet.

• Export an Excel 2007 table to a SharePoint site.

Microsoft Windows SharePoint Services provides the collaborative backbone to the 2007 Microsoft Office System. In Chapter 7, “Working with Document Workspaces,” you discovered how to share and manage documents stored in a SharePoint Web site from within the 2007 Microsoft Office suite. You also created SharePoint sites from your 2007 Microsoft Office suite applications.

This chapter focuses on the integration of Windows SharePoint Services with Microsoft Office Excel 2007, which allows you to export and import data to and from SharePoint lists. Office Excel 2007 also provides one-way synchronization from SharePoint lists to Excel 2007 spreadsheets, so you can take the data offline and then synchronize with the SharePoint lists when you reconnect.

Important  

Before you can use the practice files provided for this chapter, you need to install them from the book’s companion CD to their default location. See “Using the Book’s CD” on page xix for more information.