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.

 

About these ads

12 Responses to Office 2010 Integration with SharePoint 2010 compared with Office 2007

  1. Pingback: SharePoint 2010: Recopilatorio de enlaces interesantes (V)! « Pasión por la tecnología…

  2. Pingback: SharePoint 2010: Recopilatorio de enlaces interesantes (VI)! « Pasión por la tecnología…

  3. Pingback: SharePoint 2010: Recopilatorio de enlaces interesantes (VI)! - Blog del CIIN

  4. shira says:

    hi,
    you wrote that “Save to SharePoint” is Fully Available in office 2010 but i had office 2007 and could not Save to SharePoint then i install “Software Update for Web Folders (KB907306)” and after that i could Save to SharePoint from office 2007 but now i removed office 2007 and install office 2010 and i can not Save to SharePoint even after i install “KB907306″ again. can you help?

    • techdhaan says:

      Are u saving to MOSS 2007 or SharePoint 2010 ?

  5. shira says:

    Thanks for your response, Im saving to sharepoint 2010 and i managed to do it, all I had to do is install Desktop Experience Feature

  6. Matt says:

    Great table
    Is there one that compares all Office versions ?
    ie Office XP , 2003

    • Sai Shankar says:

      Not really, this was more focused on Office 2007/2010

  7. Lei Rus says:

    What is “Social Integration with Notes and Tags” I could not find any information about this feature…

  8. Johhny says:

    And what with different Office 2010 versions. Can I use Office home & business to work with Sharepoint.

  9. Tyler says:

    Can you tell me more about the PowerPoint “screen caputre tools” and “edit video and pictures within the document”? I’m not seeing how those integrate with SharePoint.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Follow

Get every new post delivered to your Inbox.

%d bloggers like this: