SharePoint works with Office 2000, 2002 (XP), and 2003. The feature set varies a great deal between these versions. Basically, all versions allow you to save and open files from SharePoint sites through a browser; Office 2002 supports some integration; and Office 2003 provides full integration through the Shared Documents task pane. The following table outlines how SharePoint works with the various versions of Office.
Note that SharePoint is not fully compatible with Office 2004 for the Mac. Office 2004 (Mac) can open files that came from a SharePoint server, but the program doesn’t have any understanding of SharePoint features.
Program | Feature | Office version | ||
2000 | 2002 | 2003 | ||
All | Save and open files from SharePoint sites | X | X | X |
Shared Workspace task pane | X | |||
Document updates for shared attachments | X | |||
View and edit a shared attachment | X | X | X | |
Create new documents in a web browser | X | X | ||
Collect metadata automatically | X | |||
Promote and demote file properties and metadata automatically | Limited | X | X | |
Track document versions | X | |||
Check out and check in documents | X | |||
Manage Microsoft Project documents, risks, and issues | X | |||
Upload multiple documents | X | |||
Inline discussions | X | X | X | |
Microsoft Office Components for SharePoint | X | |||
Person Names Smart Tag | X | |||
Integration with Microsoft Business Solutions | X | |||
Shared attachments | X | |||
Create Document Workspace sites | X | |||
Outlook | Create Meeting Workspace sites automatically | X | ||
Synchronize calendar and contact list sites | X | |||
Alerts | X | X | X | |
Alert integration with Outlook | X | |||
Excel | Two-way synchronization with SharePoint lists | X | ||
Export list data to Excel spreadsheet | X | X | ||
Create custom list from Excel spreadsheet | X | |||
Access | Link table to SharePoint list | X | ||
Export list data to Access database table | X | |||
Create custom list from Access database table | X | |||
FrontPage | Edit and customize Windows SharePoint Services web sites | X | ||
Create and customize data-driven web part pages | X | |||
Solution packages | X | |||
Browse and search web part galleries | X | |||
Manage list views | X | |||
Design templates | X | |||
Web part connections | X | |||
Back up and restore site | X | |||
InfoPath | Business Document Library | N/A | N/A | X |
Edit documents in InfoPath | N/A | N/A | X | |
Aggregate business reports | N/A | N/A | X |
18.217.8.82