SharePoint® 2007 Collaboration For Dummies®

Chapter 12. Using Office Applications with SharePoint

In This Chapter

• Editing an Office document saved in a SharePoint document workspace

• Saving Word documents directly to your SharePoint document libraries

• Exporting Excel worksheet data into custom SharePoint lists

• Importing Excel worksheet data into custom SharePoint lists

From the perspective of the typical SharePoint user, one of the most satisfying things about using SharePoint 2007 is how well integrated it is with the later versions of Office applications (2003 and later), especially the core programs such as Microsoft Word, Excel, and PowerPoint.

A big part of this integration is provided by the Document Management pane (called Shared Workspace in Office 2003) in these core Office programs. You can use these panes to create and maintain SharePoint document workspaces (see Chapter 9) as well as to collaboratively edit their documents. Using the controls provided by the Document Management (Shared Workspace) panes, your team members can make their edits on the document saved in the workspace on the SharePoint site, and you, as the team leader, can determine which edits to save in case of conflicting changes.

When it comes to using Word 2007 with your SharePoint site, you can not only save and upload your documents to your SharePoint document libraries (see Chapter 5 for details on creating SharePoint document libraries) but also create and post your SharePoint blog entries (see Chapter 8 for details).

When it comes to Excel and your ...