Comparison between Microsoft SharePoint 2010 with Different Versions of Microsoft Office

As SharePoint 2010 and Microsoft Office 2010 rolling out from beta version production the main concern for Organisation as well as developers is the compatibility between older versions with the newer version. Most of us already know SharePoint 2010 need 64 bit platform and to modify the site, SharePoint designer 2007 is not compatible as we must need to use SPD 2010 to do any changes.

SharePoint 2007 already have lots of important feature that go good with SharePoint and still will support many application with SharePoint 2010. I have try to trim down some information from Microsoft which features the comparison between different version of office and show what we will miss out if we don’t use Office 2010 with SharePoint 2010. The comparison based on the following areas-

  • Collaboration Without Compromise
  • Bring Ideas to Life
  • Anywhere Access
  • The Practical IT Platform

According to Microsoft –

SharePoint 2010 + Office 2007 (BETTER)- Microsoft Office 2007 provides contextual integration with Windows SharePoint Services and Microsoft Office SharePoint Server, which allows people to interact with SharePoint sites without leaving their Microsoft Office programs, and provides two-way synchronization with collaborative information, documents, and business data stored on SharePoint sites.

SharePoint 2010 + Office 2010 (BEST)Microsoft Office 2010 with SharePoint 2010 gives people the ability to view and edit with PCs, browsers, and mobile devices. This combination also includes greater capabilities for people to use Microsoft Office applications to edit documents and work with information from line-of-business (LOB) applications while offline, and then resynchronize when they’re reconnected to the network. The ability to co-author the same document or share a Microsoft Office OneNote® notebook reduces review cycles and enhances teamwork. Microsoft Office Backstage view puts many more SharePoint 2010 capabilities in the context of Office applications, including greater automation of metadata capture and streamlined access to document libraries and SharePoint workspaces.

Collaboration without Compromise



Office 2010

Office 2010

Coauthor Documents and Presentations
Share ideas with other people simultaneously and see what areas of a document have changed.
With coauthoring, work together in Microsoft Office Word 2010 and Microsoft Office PowerPoint 2010 and see others’ changes tracked as you work with documents hosted in SharePoint 2010
Simultaneously Edit Spreadsheets and Notebooks
Work together on content using a Web browser.
Work together in Microsoft Office Excel 2010 and Microsoft Office OneNote 2010 Web applications simultaneously and see others’ changes in real time.
Share a Team Notebook
Enable multiple people to add to and change the same shared notebook, and author names appear in near real time as authors make changes.
Shared OneNote 2010 notebooks provide a clear trail of what other authors have changed since the user last opened the notebook.
Partial Support.Share OneNote 2007 notebooks with other people, but without a complete audit trail.
Broadcast Slide Shows in PowerPoint
Share a PowerPoint presentation over the Web for remote or networked viewers.
Audiences do not need to have PowerPoint 2010 installed; they can view the presentation in high fidelity in a Web browser.
Save Documents and Presentations Directly to SharePoint from Office
Automatically discover the SharePoint document library to make saving the content easy and intuitive
People can save Office 2010 documents directly to the SharePoint 2010 document library from Office Backstage view.


Bring Ideas to Life



Office 2010

Office 2010

Project code-named “Gemini”
“Gemini” for Excel 2010 provides streamlined integration and Web-based analysis in SharePoint 2010. Use data from multiple sources and manipulate large data sets that have up to hundreds of millions of rows.
Publish and share analysis with less effort and enable others to enjoy the same Data Slicers and fast-query capabilities, even when they work in Excel Services reports.
Publish and Share Through Excel Services
Share analysis and results across the organization by publishing Excel spreadsheets to the Web or other SharePoint site (intranet or extranet).
Use Office Backstage view in Excel 2010 to selectively publish parts of a worksheet, hide formulas, and stage data to SharePoint 2010.
Partial Support. Manually navigate to SharePoint sites and specify which components of the workbook will be visible when published to the Excel Services site.
Microsoft Office Access Design for the Web
Microsoft Office Access applications developed in Design for Web mode can be designed and edited for publishing to SharePoint 2010, so people can share, collect, and report on data
Use Access 2010 to publish data, forms, logic/macros, and reports with nearly the same look and feel in the browser as Access 2010 on a PC.  
Automate Metadata Capture
Make information more findable, perceptible, discoverable, navigable, manageable, and re-usable.
Use Word 2010 to provide better and more automated metadata capture from Backstage view, including document information either added automatically or typed quickly in AutoComplete fields. Partial Support .Use the document information panel to manually capture metadata from within Microsoft Office 2007.
Use Office Backstage View
Seamlessly connect Microsoft Office applications with SharePoint 2010 to provide workflow integration, the ability to enter metadata, and social context.
By using the Backstage view in Office 2010 applications, people can enter metadata; interact with workflows, access authors’ profiles, and more. Because Backstage view is extensible, people can add custom actions to suit custom needs.  
Access SharePoint Templates
Access document templates stored on SharePoint 2010 more quickly and easily.
People can access document templates stored in SharePoint 2010 via the New Document wizard in Microsoft Office applications.  
Apply PowerPoint Themes to SharePoint Sites
Make customization of SharePoint 2010 sites more flexible by using themes as used in presentation decks
People can theme SharePoint 2010 sites by using the same themes as in PowerPoint 2010.  
Use Reusable Workflows
Support workflows that can be used multiple times, and provide workflow templates for later use in SharePoint 2010.
SharePoint Designer 2010 supports reusable workflows and workflows attached to content types.
Visualize Workflow
Allow a workflow designer to see the steps in a SharePoint 2010 workflow in a visual format.
Workflows developed as drawings and exported from Microsoft Office Visio® 2010 can be imported into SharePoint Designer 2010 for modification and deployment.  
Use Forms-Based Applications
Forms-based applications connect with back-end data and include workflow, reporting, custom Web pages, and other components.
Integrate InfoPath 2010 forms with back-end data by using external lists in SharePoint 2010, and include custom sandboxed solution code.


Anywhere Access


  Office 2010 Office 2007
View and Edit Documents, Spreadsheets, Presentations, and Notebooks in the Browser
Allow editing, even if applications are not loaded on a PC.
View and make light edits to documents through Office Web applications in a browser. Document formatting and content are maintained when changes are made in the browser, because Web applications can be hosted on the premises, running in SharePoint.
Mobile Access Enhancements
View and edit documents from a mobile device, even when on the go.
View Office 2010 documents from virtually anywhere with Web applications without losing fidelity, and make changes with limited editing capabilities.
Work Offline with an Improved Experience in Microsoft Office Access
Edit Office Access forms, reports, queries, and macros offline and synchronize changes in SharePoint when reconnected to the network.
Data in Microsoft SharePoint 2010 lists is cached in Access 2010 by default.
Before working offline with data from SharePoint sites, people must manually create links between Access 2007 tables and SharePoint 2010 lists.
Collaborate Offline and Online
Work offline with SharePoint 2010 contents and when reconnected to the network, changes are synchronized.
Work offline with SharePoint 2010 document libraries and lists through SharePoint Workspace 2010. Work offline in SharePoint 2010 document libraries only through Microsoft Office Groove®.
Fill In Forms Offline
SharePoint list forms are synchronized with the workspace so people can work offline.
SharePoint 2010 list items open in an InfoPath 2010 form that is hosted in SharePoint for edit in display mode.  
Extend the Reach of Forms
Fill in InfoPath forms from a Web browser, while online or offline, and from a mobile device.
The InfoPath 2010 forms solution offers embedded solutions using InfoPath controls that can be hosted. Limited InfoPath 2007 controls work on Web-enabled and mobile forms
Publish Access Databases to the Web
Securely publish database applications to the Web so IT managers can meet requirements for data compliance, backup, and audits.
While publishing data, Access 2010 checks for incompatible objects and builds a report of any runtime differences between the client and server.
While publishing data from Access 2007, people must manually check whether objects created in Access can be supported in the server or not.


The Practical IT Platform



Office 2010

Office 2007

Integrate LOB Data Offline and Online
Take LOB data offline, and then synchronize changes automatically when back online.
Synchronize LOB data in both directions between SharePoint Workspace 2010 and enterprise line-of-business systems by bringing LOB data into SharePoint 2010 Sites, and then taking that data offline via SharePoint Workspace 2010.
Use Business Data Applications
Design forms for SharePoint 2010 that creates, read, update, and delete business data from a back-end system.
Business data applications start with an external list in SharePoint 2010 and use InfoPath Designer 2010 to create custom forms on top of the list.
Enhance Information Security and Integrity with Digital Signatures
Help ensure the integrity of information contained in forms with the controls necessary to enable single, co-sign, and counter-sign scenarios for the full form or portions of the form.
InfoPath 2010 and SharePoint 2010 support cryptography next-generation (CNG) digitally signed content.
Publish Forms in a Single Click
Avoid clicking through the Publishing Wizard every time you update forms published in SharePoint 2010
Use ―quick publish functionality in InfoPath 2010 to publish forms to SharePoint 2010 in a single click. Publish data from forms through a publishing wizard.
Manage Forms More Easily
More easily manage form versions, updates, and upgrades in SharePoint 2010 to ensure that team members are working on the correct version of a form.
Automate template version management with SharePoint 2010 and InfoPath 2010 to provide an improved process for checking for template updates.  
Use Line of Business Data in Applications
Provide a SharePoint-based framework for creating Office Business Applications.
Business Connectivity Services (BCS) provides the read/write capability to connect SharePoint 2010 and Microsoft Office client applications to external data sources (such as SQL, Oracle, SAP, CRM, Siebel, Web services, and custom applications). Use the Business Connectivity Services within SharePoint to provide read access and surface line-of-business information in Office client applications
Package and More Easily Move InfoPath Applications
More easily move InfoPath applications from site to site and server to server.

InfoPath 2010 applications can be packaged more quickly and easily by using the Windows SharePoint Services solutions (.wsp) and SharePoint site template (.stp) file formats.


This entry was posted in SharePoint 2010 and tagged . Bookmark the permalink.

3 Responses to Comparison between Microsoft SharePoint 2010 with Different Versions of Microsoft Office

  1. Pingback: Microsoft Office 2010 with Different Versions of Microsoft SharePoint « Mrin's Blog

  2. Priyanka says:

    Can you please elaborate on how I can hide formula in excel sheet for Sharepoint 2010

Leave a Reply

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

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

Google+ photo

You are commenting using your Google+ 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 )


Connecting to %s