Office 2010 Integration with SharePoint 2010 compared with Office 2007


Based on my recent work with SharePoint 2010 and Office 2010, here is a list of my observations of the differences between the two versions of Office when integrating with SharePoint 2010.

Click here to download a PDF version of this comparison

Some enterprises may decide to rollout SharePoint 2010 without upgrading Office. In this case, here are the features that you will miss out on!. This is not a comprehensive nor the official list and is based on my initial experiences. Please post in the comments if you have additional features or if some of these work in 2010

Legend –

Fully Available – Fully Available

Unavailable – Unavailable

Partially Available – Partially Available

Word

Feature Word 2007 Word 2010
Save to SharePoint Fully Available Fully Available
View and Manage Versions Fully Available Fully Available
View/Manage/Start Workflows Fully Available Fully Available
View and Manage Workflow Tasks Fully Available Fully Available
Co-Authoring of the same document simultaneously Unavailable Fully Available
Set Managed Metadata Properties Unavailable Fully Available
One click document synchronization with the server Unavailable Fully Available
Social Integration with Notes and Tags Unavailable Fully Available
Office BackStage Unavailable Fully Available

PowerPoint

Feature PowerPoint 2007 PowerPoint 2010
Save to SharePoint Fully Available Fully Available
View and Manage Versions Fully Available Fully Available
View/Manage/Start Workflows Fully Available Fully Available
View and Manage Workflow Tasks Fully Available Fully Available
Co-Authoring of the same document simultaneously Unavailable Fully Available
Set Managed Metadata Properties Unavailable Fully Available
One click document synchronization with the server Unavailable Fully Available
Social Integration with Notes and Tags Unavailable Fully Available
Office BackStage Unavailable Fully Available
Slideshow Broadcasting from Powerpoint through PowerPoint web app Unavailable Fully Available
Edit Video and Pictures within the document Unavailable Fully Available
Screen Capture Tools Unavailable Fully Available

SharePoint Designer

SharePoint Designer 2010 is required to edit SharePoint 2010 sites. It is not backward compatible with MOSS 2007 either.

Outlook

Feature Outlook 2007 Outlook 2010
Social connector to LinkedIn Unavailable Fully Available
Take SharePoint lists offline Fully Available Fully Available
Overlay Calendars Partially Available Fully Available
Plug-ins to connect to SharePoint social features Unavailable Fully Available

Visio

Feature Visio 2007 Visio 2010
Save to SharePoint Unavailable Fully Available
View and Manage Versions Unavailable Fully Available
View/Manage/Start Workflows Unavailable Fully Available
View and Manage Workflow Tasks Unavailable Fully Available
Publish to Visio Web Services from the client Unavailable Fully Available
Build Workflows for SharePoint Unavailable Fully Available
Import Visio Workflows to SharePoint Designer 2010 Unavailable Fully Available
Office Backstage Unavailable Fully Available

Excel

Feature Excel 2007 Excel 2010
Save to SharePoint Fully Available Fully Available
View and Manage Versions Fully Available Fully Available
View/Manage/Start Workflows Fully Available Fully Available
View and Manage Workflow Tasks Fully Available Fully Available
Co-Authoring of the same document simultaneously Unavailable Fully Available
Set Managed Metadata Properties Unavailable Fully Available
One click document synchronization with the server Unavailable Fully Available
Office BackStage Unavailable Fully Available
Improved Publishing to Excel Web Access Partially Available Fully Available
Excel SparkLines Unavailable Fully Available
Excel data slicers Fully Available

InfoPath 2010

InfoPath 2010 is needed for customizing the display forms in SharePoint. Forms can be filled in but will not support the features like BCS metadata controls and people selected controls.

 

Office 2007 Integration with SharePoint


One of the frequent questions we encounter from our customers is

“Why do I need Office 2007 and how does it integrate with MOSS 2007”

Here is a great post on the  integration of the different Office applications with SharePoint

http://blogs.msdn.com/brittog/archive/2007/02/16/wht-you-get-with-office-2007.aspx

%d bloggers like this: