7.6. Summary
In this chapter, you examined the basic collaboration features between SharePoint and Excel 2007. You started by exporting the metadata from a document library to an Excel worksheet. If you include a SharePoint column that also includes a link to the document itself, you can open the document from Excel by clicking the link.
While at first it may seem that the collaboration between these two products works like SharePoint's collaboration with other Office products such as MS Word, you quickly discovered that it actually has at least one serious limitation. While you can export data from SharePoint to Excel, and you can refresh Excel with changes made in SharePoint, you cannot send changes made to the Excel worksheet back to the ...
Get Office and SharePoint 2007 User's Guide: Integrating SharePoint with Excel, Outlook, Access, and Word now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
