Office 2010 Integration with SharePoint 2010 compared with Office 2007
March 5, 2010 12 Comments
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
– Unavailable
– Partially Available
Word
| Feature | Word 2007 | Word 2010 |
| Save to SharePoint | |
|
| View and Manage Versions | |
|
| View/Manage/Start Workflows | |
|
| View and Manage Workflow Tasks | |
|
| Co-Authoring of the same document simultaneously | |
|
| Set Managed Metadata Properties | |
|
| One click document synchronization with the server | |
|
| Social Integration with Notes and Tags | |
|
| Office BackStage | |
|
PowerPoint
| Feature | PowerPoint 2007 | PowerPoint 2010 |
| Save to SharePoint | |
|
| View and Manage Versions | |
|
| View/Manage/Start Workflows | |
|
| View and Manage Workflow Tasks | |
|
| Co-Authoring of the same document simultaneously | |
|
| Set Managed Metadata Properties | |
|
| One click document synchronization with the server | |
|
| Social Integration with Notes and Tags | |
|
| Office BackStage | |
|
| Slideshow Broadcasting from Powerpoint through PowerPoint web app | |
|
| Edit Video and Pictures within the document | |
|
| Screen Capture Tools | |
|
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 | |
|
| Take SharePoint lists offline | |
|
| Overlay Calendars | |
|
| Plug-ins to connect to SharePoint social features | |
|
Visio
| Feature | Visio 2007 | Visio 2010 |
| Save to SharePoint | |
|
| View and Manage Versions | |
|
| View/Manage/Start Workflows | |
|
| View and Manage Workflow Tasks | |
|
| Publish to Visio Web Services from the client | |
|
| Build Workflows for SharePoint | |
|
| Import Visio Workflows to SharePoint Designer 2010 | |
|
| Office Backstage | |
|
Excel
| Feature | Excel 2007 | Excel 2010 |
| Save to SharePoint | |
|
| View and Manage Versions | |
|
| View/Manage/Start Workflows | |
|
| View and Manage Workflow Tasks | |
|
| Co-Authoring of the same document simultaneously | |
|
| Set Managed Metadata Properties | |
|
| One click document synchronization with the server | |
|
| Office BackStage | |
|
| Improved Publishing to Excel Web Access | |
|
| Excel SparkLines | |
|
| Excel data slicers | |
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.
Shankar's Musings 
Pingback: SharePoint 2010: Recopilatorio de enlaces interesantes (V)! « Pasión por la tecnología…
Pingback: SharePoint 2010: Recopilatorio de enlaces interesantes (VI)! « Pasión por la tecnología…
Pingback: SharePoint 2010: Recopilatorio de enlaces interesantes (VI)! - Blog del CIIN
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?
Are u saving to MOSS 2007 or SharePoint 2010 ?
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
Great table
Is there one that compares all Office versions ?
ie Office XP , 2003
Not really, this was more focused on Office 2007/2010
What is “Social Integration with Notes and Tags” I could not find any information about this feature…
And what with different Office 2010 versions. Can I use Office home & business to work with Sharepoint.
Hi Johhny
Check this link for some discussions
http://social.technet.microsoft.com/Forums/en-US/sharepoint2010setup/thread/337b6243-64fe-4a29-a657-98ac66549fc3/
http://office.microsoft.com/en-us/home-and-business/
It looks like Co-Authoring is enabled which means you should be able to consume content from a SharePoint site assuming you have the right CALs.
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.