Overview of Office and SharePoint Integration Features Office 2000 vs. Office XP vs. Office 2003 Editions with Windows SharePoint Services 3.0 or Office SharePoint Server 2007 The following shows the richness of the integration features of Office 2000 versus Office XP versus the Office 2003 Editions with Windows SharePoint Services 3.0 and Office SharePoint Server 2007. These integration features are identical to what you would experience with Windows SharePoint Services 2.0 and SharePoint Portal Server 2003 as previously described in the or . Feature Office 2000 Office XP Office 2003 Editions Save and open files from SharePoint sites Yes (Excel, FrontPage, PowerPoint, Microsoft Project, Word) Yes (Excel, FrontPage, PowerPoint, Microsoft Project, Visio, Word) Enhanced (Excel, FrontPage, InfoPath, OneNote, Outlook, PowerPoint, Microsoft Project, Publisher, Visio, Word) Create new documents in Web browser No Yes (Excel, FrontPage, PowerPoint, Word) Yes (Excel, FrontPage, InfoPath, PowerPoint, Microsoft Project, Publisher, Word) Collect metadata automatically No No Enhanced (Excel, PowerPoint, Word) Promote and demote file properties and metadata automatically Data stored, but not displayed (Excel, FrontPage, PowerPoint, Word) Yes (Excel, FrontPage, PowerPoint, Word) Enhanced (Excel, FrontPage, InfoPath, PowerPoint, Visio, Word) document versions No. Use Web browser to view and manage document versions. No. Use Web browser to view and manage document versions. Enhanced (Excel, PowerPoint, Visio, Word) Check-out and check-in documents No. Use Web browser to manually check-out and check-in documents. No. Use Web browser to manually check-out and check-in documents. Enhanced (Excel, PowerPoint, Visio, Word). Use Web browser to manually check-out and check-in other types of documents. Manage Microsoft Project documents, risks, and issues No No Yes Upload multiple documents No No Yes Inline discussions Yes Yes Yes Microsoft Office Components for SharePoint No No Yes Person Names Smart Tag No No Yes
Export Table to SharePoint site Non-linked access to list in browser Link to SharePoint List from Access 2003 Edit Data in Table with Browser Edit Data directly in in Access 2003 Data tables are linked to SharePoint Lists Data tables are linked to SharePoint Lists Access Forms converted to browser forms Continue to use Access 2007 client with this data Groove and SharePoint Integration Enables Groove users to have offline access to SharePoint document libraries. Groove and SharePoint Integration 2003 Client Experience 2007 Client Experience Groove 3.1 does not support direct access to contents of SharePoint Server 2007 document libraries. Contents of libraries can be added to workspace but no synchronization service provided. Issue: Limited ability to combine usage of SharePoint server team sites and Groove workspaces. Adding documents to a Groove Workspace is a easy to mange process that automates the synchronization of the copies. Benefit: Improved utilization of the tools and more effective collaboration especially for highly mobile users who are frequently disconnected. Integrating Groove 3.1 and SharePoint document libraries can be done in a limited fashion. Files residing in a SharePoint document library can be added to the Groove 3.1 workspace. No synchronization service is provided between the Groove workspace and the SharePoint document library and the files quickly can get out of sync. Groove 2007 provides a streamlined experience for connecting workspaces to SharePoint document libraries. A special purpose “SharePoint Files” tool makes the process of bringing files into the groove workspace easy. The Groove 2007 client provides synchronization services. If the file is modified in the Groove workspace – notification is provided reminding the user to synchronize. All synchronizations are previewed prior to execution. Add files to Groove 3.1 Workspace SharePoint Files tool to get files
Appendix Client Program, Server License, and Client Access License Requirements The following shows the Office 2003 or 2007 client program, SharePoint server license, and client access license requirements for each of the major Office and SharePoint integration feature. Client Program, Server License, and Client Access License Requirements Office and SharePoint Integration Feature Client(s) Server(s) CAL(s) Enterprise Content Management Publish documents to server to enable content management in the client (e.g., start and/or participate in approval or review workflows from within the Office client), access content management features from within client (e.g., auto-generated document properties) Word, Excel, PowerPoint Microsoft Office SharePoint Server (MOSS) 2007 MOSS Standard CAL Information Rights Management Protect documents from unauthorized access or distribution from within the Office client applications. Excel, InfoPath, Outlook, PowerPoint, Word Windows Server 2003 w/ Windows Rights Management Services (WRMS) WRMS CAL Windows Server CAL PowerPoint Slide Libraries Publish slides to server where they can be easily shared, access slides on Slide Library from within PowerPoint, receive notification if slide on server changes. PowerPoint MOSS MOSS Standard CAL Excel Services Publish Excel spreadsheets to server for centralized management, browser-based spreadsheet viewing and access control. Excel MOSS MOSS Standard CAL + MOSS Enterprise CAL Electronic Forms (Complete) Publish forms to server to enable browser-based access for data collection, initiate workflows and additional forms management tasks from InfoPath client. InfoPath MOSS MOSS Standard CAL + MOSS Enterprise CAL Electronic Forms (Limited) Publish to server to enable browser-based access for data collection. InfoPath Office Forms Server (OFS) OFS CAL Outlook/SharePoint Integration Keep synchronized copy of SharePoint Calendars, Tasks, and Contacts and offline access to SharePoint Document Libraries in Outlook. Outlook WSS 3.0 - or - MOSS Windows Server CAL - or - MOSS Standard CAL Access/SharePoint Integration Move Access data to a SharePoint site where it can be centrally managed and accessible by the client or a browser. Access WSS 3.0 - or - MOSS Windows Server CAL - or - MOSS Standard CAL
Groove/SharePoint Integration Take synchronized copy of SharePoint Document Libraries offline in a Groove Workspace. Groove WSS 3.0 - or - MOSS Windows Server CAL - or - MOSS Standard CAL OneNote/SharePoint Integration Store a Shared Notebook in a SharePoint Document Library, which enables collaborative content editing by multiple OneNote users. OneNote WSS 2.0 or 3.0 - or - SPS 2003 or MOSS Windows Server CAL - or - SPS 2003 CAL or MOSS Standard CAL