Chapter 12: Using Windows SharePoint Services with Excel 2007


image from book Download CD Content

Chapter at a Glance

image from book

image from book
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.

image from book

In This Chapter, You will Learn to:

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

  • image from book Use the Access Web Datasheet.

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

  • image from book 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. image from book




Microsoft Windows Sharepoint Services Version 3. 0 Step by Step
Microsoft Windows Sharepoint Services Version 3. 0 Step by Step
ISBN: 735623635
EAN: N/A
Year: 2004
Pages: 201

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net