Essential SharePoint 2007, 2nd Edition

Appendix B. Reference Tables

Office Versions

SharePoint works with Office versions 2000 to 2007. However, the feature sets vary a great deal among these versions. Basically, all versions allow you to save and open files from SharePoint sites through the browser; 2002 supports some integration (export list to spreadsheet); and 2003 provides full integration through the Shared Documents task pane. Table B-1 further details Microsoft Office version compatibility.

Table B-1. Microsoft Office version compatibility

Product	Feature	Office version
		2000	2002	2003	2007
All	Save and open files from SharePoint sites	X	X	X	X
	Shared Workspace task pane			X	X
	Document updates for shared attachments			X	X
	View and edit a shared attachment	X	X	X	X
	Create new documents in web browser		X	X	X
	Collect metadata automatically			X	X
	Promote and demote file properties and metadata automatically	Limited	X	X	X
	Track document versions			X	X
	Check out and check in documents			X	X
	Manage Microsoft Project documents, risks, and issues			X	X
	Upload multiple documents			X	X
	Inline discussions	X	X	X	X
	Microsoft Office Components for SharePoint			X	X
	Person Names Smart Tag			X	X
	Integration with Microsoft Business Solutions			X	X
	Shared attachments			X	X
	Create Document Workspace sites			X	X
Outlook	Create Meeting Workspace sites automatically			X	X
	Synchronize calendar and contact list sites			X	X
	Receive alerts	X	X	X	X
	Alert integration with Outlook			X	X
Excel	Two-way synchronization with SharePoint lists			X	X
	Export list data to Excel spreadsheet		X	X	X
	Create custom list from Excel ...