SharePoint 2007 vs SharePoint 2010

Everything on this page is contained in Microsoft documentation, on the Microsoft website, on MSDN, on Technet, or in the Microsoft webcasts and presentations. As you can imagine it is placed in multiple pages, across multiple documents, and some of it is contained within specific Microsoft presentations. My goal with this page is to just have all of the comparison information in one place.

Note: I have used symbols here instead of images so it’s easier to copy and paste into a document or another location. So they may not look as nice, but you can use things like find and replace, as well as filter the values if you merge the tables.

Quick Links: Sites |  Communities | Content | Search | Insights | Composites | Office 2010 | Architecture | Web Services/OM | Editions | Administration


= Feature Included

= Improved In Office Sharepoint Server 2010

= New In Office Sharepoint Server 2010


Feature Name / Area

Sharepoint Server 2007

Sharepoint Server 2010

Office Integration

Line-Of-Business Integration

  • Read/Write Capabilities

Enterprise Management Operations

  • Management Tools And Reporting

  • Web Analytics

Mobile Connectivity

  • Full-Fidelity Viewing

  • Editing To Mobile

Office Interaction

  • Read/Write Capabilities

Robust User Experience

  • Contextual Ribbon

  • Microsoft Silverlight

Office Web Applications




Audience Targeting


Back to top…



Feature Name / Area

Server 2007

Server 2010

My Site: People Profile & Personal Site

Photos And Presence

Status Updates

Ask Me About


Note Board


Recent Activities


Organization Browser


Add Colleagues

Social Bookmarks




Tag Clouds


Tag Profiles


My Network




Enterprise Wikis




Colleague Suggestions

Keyword Suggestions


Back to top…



Feature Name / Area

Server 2007

Server 2010

Compliance Everywhere


Flexible Records Management


Shared Content Types And Managed Metadata Service


Content Organizer


Rich Media Management


Document Sets


Word Automation Services


Support For Accessibility


Back to top…



Feature Name / Area

Server 2007

Server 2010

People And Expertise Search


Search From Windows 7 And Windows Mobile

Common Connector Framework For Indexing And Federation

Scale And Performance Via Improved Topology Architecture

Ability To Build Search-Powered Applications

Refinement Panel And Sorting


Search In Context


Social Behavior Improves Relevance


Thumbnails, Previews, And View In Browser


Back to top…



Feature Name / Area

Server 2007

Server 2010

KPI Details


Dashboard Designer

Enhanced Navigation, Including Filtering And Sorting (Top/Bottom 10, Switchable Measures)


Publish More Workbooks


Javascript Object Model


Powershell Scripting


Richer Fidelity With Excel Workbooks


Support For Analytical Services Formatting


Additional Data Sources, Including External Lists And “PowerPivot” Workbooks


Improved Strategy Map Connection And Formatting


Seamless Management Of Dashboard Content

Integrated Filter Framework


Calculated KPIs


Improved Visualizations


Chart Web Parts


Business Intelligence Center

(Report Center)

Back to top…


Feature Name / Area

Server 2007

Server 2010

Browser-Based Customizations


Business Connectivity Services


Sharepoint Designer

Human Workflows

Forms Services

Visio Services


Access Services


Sandboxed Solutions


Back to top…

Microsoft Office 2010 with Different Versions of SharePoint

Feature Name/Area


SharePoint 2010

SharePoint 2007

Documents and Presentations

ideas with other people simultaneously and see what areas of a document have

coauthoring, work together in Microsoft Office Word 2010 and Microsoft Office
PowerPoint 2010, and see others’ changes tracked in documents hosted in
SharePoint 2010.


Edit Spreadsheets and Notebooks

together on content using a Web browser

together in Microsoft Office Excel 2010 and Microsoft Office OneNote 2010 Web
applications simultaneously and see others’ changes in real time.


Changes in Shared Notebooks

multiple people to add to and change the same shared notebook. Author names
appear in near real time as changes are made.

OneNote 2010 notebooks provide a clear trail of what other authors have
changed since the last user opened the notebook.



Slide Shows in PowerPoint

a PowerPoint presentation over the Web for remote or networked viewers.

do not need to have PowerPoint 2010 installed; they can see the presentation
in high fidelity in a Web browser.


Documents and Presentations Directly to SharePoint


discover SharePoint document libraries to make saving content easier and more

can save Office 2010 documents directly to the SharePoint 2010 document
library from Office Backstage view.





for Excel 2010 provides streamlined integration and Web-based analysis in
SharePoint. Use data from multiple sources and manipulate large data sets
that have up to hundreds of millions of rows.

and share analysis with less effort and enable others to enjoy the same Data
Slicers and fast-query capabilities, even when working in Excel Services


and Share Information Through Excel Services


analysis and results across the organization by publishing Excel 2010 spreadsheets
to the Web or other SharePoint sites (intranet, extranet).

Backstage view in Excel 2010 to selectively publish selective parts of a
worksheet, hide formulas, and stage data to SharePoint 2010.


Backstage view in Excel 2010 to selectively publish parts of a worksheet to
SharePoint 2007.


Office Access Design for the Web


Office Access 2010 applications developed in
Design for Web mode can be designed
and edited for publishing to SharePoint, so people can share, collect, and
report on data.

Access 2010 to publish data, forms, logic/macros, and reports with nearly the
same look and feel in the browser as in Access 2010 on a PC.



Metadata Capture


better, automated metadata capture in SharePoint to make information more
findable, perceptible, discoverable, navigable, manageable, and re-usable.

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.


2010 provides automated metadata capture from Backstage view, including
document information added automatically.


Office Backstage View


connect Office 2010 applications with SharePoint to provide workflow
integration, the ability to enter metadata, and social context.

using Office Backstage view in Office 2010 applications, people can enter
metadata, interact with workflows, access authors’ profiles, view recent
content the author has created in SharePoint 2010, and more.

using Office Backstage view in Office 2010 applications, people can enter
metadata and interact with workflows


SharePoint Templates

Office 2010 document templates stored in SharePoint more quickly and easily.

can access document templates stored in SharePoint 2010 via the
New Document wizard in Office 2010



PowerPoint Themes to SharePoint


customization of SharePoint sites more flexible by using themes used in
PowerPoint 2010 presentations.

can apply themes to SharePoint 2010 sites by using the same themes as in
PowerPoint 2010.



Reusable Workflows


workflows to be used multiple times and provide workflow templates for later
use in SharePoint.

Designer 2010 supports reusable workflows and workflows attached to content





a workflow designer to see the steps in a SharePoint workflow in a visual

developed as drawings and exported from Office Visio 2010 can be imported
into SharePoint Designer 2010 for modification and deployment.


Forms-Based Applications


applications connect with back-end data and include workflow, reporting,
custom Web pages, and other components.

InfoPath 2010 forms with back-end data by using external lists in SharePoint
2010, and include custom sandboxed solution code.



the Office Ribbon for InfoPath Forms Web Services


the Fluent Office Ribbon interface for Web-enabled forms so people can easily
find, access, and use the features they want when designing Web-enabled

used with SharePoint 2010, InfoPath Forms Services provides Web-enabled forms
with their commands in a Ribbon interface.



and Edit Documents, Spreadsheets, Presentations, and Notebooks in the Browser


editing, even if applications are not loaded on a PC.


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 and Web applications can be hosted on the premises running in


Access Enhancements


and edit documents from a mobile device even when on the go.

Office 2010 documents from virtually anywhere by using Web applications,
without losing fidelity, and make changes with limited editing capabilities.


Offline with an Improved Experience in Microsoft Office Access


Office Access 2010 forms, reports, queries, and macros offline and
synchronize changes in SharePoint when reconnected to the network.

in SharePoint 2010 list is cached in the Access 2010 by default.



Offline and Online


offline with SharePoint contents and when reconnected to the network, changes
are synchronized.

offline in SharePoint 2010 document libraries and lists through SharePoint
Workspace 2010.


In Forms Offline


list forms are synchronized so people can work offline.

2010 list items open in an InfoPath 2010 form that is hosted in SharePoint
for edit in display mode.


the Reach of Forms


in InfoPath 2010 forms in a Web browser, while online or offline, and from a
mobile device.

InfoPath 2010 forms solution offers embedded solutions that use InfoPath
controls that can be hosted.



Access Databases to the Web


publish database applications to the Web so IT managers can meet data
compliance, backup, and audit requirements.

publishing data, Access 2010 checks for incompatible objects and builds a
report of any runtime differences between the client and server.



Business Data Applications


forms for SharePoint that create, read, update, and delete business data from
a back-end system.

data applications start with an external list in SharePoint 2010 and use
InfoPath Designer 2010 to create custom forms on top of the list.


and Online LOB Integration


LOB data offline and synchronize changes automatically when back online.

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 it offline via SharePoint Workspace 2010.


Information Security and Integrity with Digital Signatures


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.

2010 and SharePoint 2010 support CNG digitally signed content.


Forms More Easily


easily manage form versions, updates, and upgrades in SharePoint to ensure
that team members are working in the correct version of a form.

template version management with SharePoint 2010 and InfoPath 2010 to provide
an improved process for checking for template updates.



Line of Business data in applications


a SharePoint-based framework for creating Office Business Applications.

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

Business Data Catalog within SharePoint to provide read access and surface
line of business information in Office client applications


Connectivity Services: Use Data as Document Properties


LOB data as document properties to make critical information more findable,
perceptible, and re-usable in SharePoint.

BCS data as Word 2010 document properties and insert it into documents.

and More Easily Move SharePoint Applications

InfoPath applications more easily from site to site and server to server.


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

Back to top…

Architecture Comparison

Back to top…

Web Services/Object Model

Available with SharePoint 2007:

  • Administration
  • Alerts
  • Authentication
  • Data Retrieval
  • Permissions
  • Sites
  • Search
  • People and Profiles
  • Workflow

New with SharePoint 2010:

  • List REST access with ADO.NET Data Services
  • Excel Services REST access
  • Client Object Model
  • WSRP (v1.1) Consumer Web Part

Back to top…


v Enterprise Client Access License

v Standard Client Access License

v SharePoint Server 2010 for Internet Sites, Enterprise

v SharePoint Server 2010 for Internet Sites, Standard

v SharePoint Foundation 2010 (Free)

v SharePoint Designer 2010 (Free)

Microsoft has created a fantastic interactive chart here  that goes through each edition.

Back to top…

What’s New For Administrators

Available in SharePoint 2010:

IT Pro Productivity

SharePoint Best Practices Analyzer
Backup And Restore Configuration Data
Site Collection Migration
Content Recovery Down To The Site And List Level
Content Restore Of Site Or List
Windows PowerShell™ Snap-Ins And Commands
Managed Accounts
Correlation IDs

Scalable Unified Infrastructure

Shared Service Applications
Hosting And Multi-Tenancy Architecture With Site Subscriptions
Claims-Based Authentication
Profile Synchronization
High Availability Automatic Failover
Content Type Syndication
Sandbox Solutions
List Throttling
Remote Blog Storage

Flexible Deployment

Prerequisite Installer
Visual Upgrade
Configuration Wizards
Scriptable Deployment
On-Premise Or Online


Unified Logging Service (ULS)
Usage Database
Developer Dashboard

Reliability and Monitoring

SharePoint Maintenance Engine (SPME) Rules
System Center Operations Manager (SCOM) Monitoring


Out of the Box Usage Reports
SCOM Reports

Back to top…

I will try and update this page from time to time with more relevant material (if you know of any please comment here).

Hope this helped someone,
Richard Harbridge

{ 6 trackbacks }

MS SharePoint 2010 explained in detail | ITCS Industry Blog
April 9, 2012 at 2:10 pm
Evento: Disponibles los materiales del evento Microsoft SharePoint Solutions Roadshow! - Blog del CIIN
June 7, 2012 at 4:17 am
Sample Fit/Gap Analysis for SharePoint 2010 Migration from SharePoint 2007 « Charlie Slack's Web Site
July 18, 2012 at 10:02 am
My Links – SP2010 « sharepointarchitecture
August 4, 2012 at 7:23 am
Research Links for Permissions | Cameron Stewart
March 14, 2013 at 8:01 am
SharePoint 2010 | Pampa Point
November 20, 2013 at 3:53 pm

{ 26 comments… read them below or add one }

1 Eric Landry June 6, 2011 at 2:20 pm

Mr. Harbridge! Thanks very much Richard. I’m working with a team on a SharePoint 2010 upgrade and this such a great summary. Hope you’re well and um, sorry about those Bruins bro.


2 Eric Landry June 6, 2011 at 2:34 pm

Oh, and I hope the W3C dude calms himself down, does some yoga, or maybe vicodin.


3 SPnewcomer June 20, 2011 at 9:27 am

Hey thanks for the writeup. It was great to get all the differences at one shot rather than searching in different documents.


4 NLV June 29, 2011 at 2:27 am

Greatly helpful. Thanks for the excellent post.


5 Maverick July 17, 2011 at 3:52 am

Hi Richard

Excellent Stuff !! I would also like to seek your opinion on whether its possible to synchonize between Sharepoint 2007 and Sharepoint 2010 using a good replication/sync tool. [email redacted]

Thanks for your help



6 Richard Harbridge January 3, 2012 at 12:27 pm

The short answer is yes. 🙂

The long answer is that it depends on what it is you are trying to synch. 🙂


7 October 3, 2011 at 12:59 pm

In SharePoint Designer 2007, you use to be able to select multiple files to do a find/replace and the option to select “Find in source code” now that option is not available in 2010, nor does the find/replace seem to work when selecting multiple files.


8 Maureen November 10, 2011 at 12:13 pm

Excellent! Thanks so much. This is exactly what I needed to make my business case for going to SP 2010.


9 vijay November 28, 2011 at 5:16 pm

very much helpful.


10 TMullenaux January 6, 2012 at 2:42 pm

Many thanks! You’ve saved many of us a lot of work!


11 subbareddy kola January 25, 2012 at 2:10 pm

This very useful information for admins and sp designers ….thank u very much giving like this information..


12 Raj March 25, 2012 at 5:06 pm

Hi Richard –

This page is very helpful! Please let me know if I can use the information presented on this page for one of my customers’ request on research materials for their potential upgrade from MOSS 2007 to SP 2010.



13 Richard Harbridge March 26, 2012 at 1:54 pm



14 Val Blatt May 3, 2012 at 9:27 pm

Hi, Richard! Ditto to almost what everyone else has said. Thank you.


15 Claude May 4, 2012 at 5:51 am

I am looking at a project involving the SharePoint workflow functionality, and am trying to assess what benefits version 2010 provide against the existing functionality on 2007. I don’t believe our use of SharePoint is quite right for the task we asking it to do – essentially create workflows from incoming emails (both internal and external) and shifting them around a number of departments and global hubs – and certainly the architects are not keen on this idea.

The business, however, quite like the current solution – although accepting that it is not perfect. My task is to assess whether or not SharePoint can actually handle this – there could be well in excess of 500,000 individual work items per year – or if it is much wiser to leave this to a more specialised solution. I have my thoughts on this, but cannot back them up with any levels of expertise. Is this something you have come across before?


16 Richard Harbridge May 29, 2012 at 10:56 am

I have come across some pretty beefy workflow implementations, and considerably complex large list/content scenarios. I would need more information to make an informed opinion/recommendation on it, but in general I wouldn’t recommend what you are suggesting.

READ THIS CAREFULLY: – While this is 2007 based, it’s still more or less accurate on most counts (if not all). Remember that 2010 uses the same workflow engine.

These are some example concerns:

1. SharePoint throttles the workflow events and by default I think is set for only so many active workflows at a time. – This can be important because you might get a massive number of emails at once. As an example processing insurance claims would result in large volumes after larger accidents – these claims would also need to be responded to within minutes, and by default the timer jobs run every 5 minutes, as well as challenges around priority of workflows… I wouldn’t recommend it for a situation like this for reliability reasons (re: throttling).

2. To function you would need some data store with 500,000 items a year. Assuming this might be a number of libraries or lists this causes it’s own set of scaling challenges, especially if the workflow performs updates or changes to the items (and is not just reading the items) – read operations scale well past 100,000 but the other methods don’t as well. From a planned retention of workflow history and actions we can assume there will be double if not considerably more. That means well over 1 million records for auditing purposes every year. This is pushing complexity and to be honest SharePoint’s interfaces don’t scale well – you would need custom interfaces for all of this.

3. You run into challenges around how many workflows can really be started within a few seconds. Even if you threw hardware at the problem after 6 servers or so it doesn’t really scale as well… So I can’t think of a hardware architecture that would scale reliably (then think of the DR planning as this sounds like a business critical process)… So the costs and scale are concerns on their own.

Honestly for this I would look at a more transaction focused business process management solution, or feel free to send me a message on linked in and we can discuss in greater detail via email. I have a few vendors I might recommend, but would need to know more. 🙂


17 ahsiao May 28, 2012 at 1:35 pm

Thanks Richard! This list cleared up quite a few things for me, fantastic.


18 Sandeep Nadig June 5, 2012 at 6:13 am

Thanks Richard! Very usefull information


19 peter June 19, 2012 at 7:09 am

Great! helped a lot.


20 Govind December 4, 2012 at 11:16 pm

This is really fantastic writeup.Please include sharepoint 2013 also 🙂


21 Sushant December 24, 2012 at 12:44 pm

Fantastic Comparision you have done your best


22 Karmit Herzog May 17, 2013 at 6:18 am

I’ve gone over this list and the list of features as compared to 2013, and it seems that there are still several necessary features that haven’t been implemented. For example, wiki improvements still don’t make Confluence’s add-on redundant and the mobile support is still on a browser-website basis, which means that’s SharePoint for mobile ( apps are still relevant.


23 Eugene Rosenfeld January 13, 2014 at 3:11 pm

Great write-up!


24 Hiranya April 29, 2014 at 6:04 am

Very spectacular Information….Keep rocking Richard


25 Vijay June 11, 2014 at 9:38 am

Hi Richard, Thanks for the wonderful summary. I was accustomed to use the SP2007 ‘Send immediate alert:’ function that I use to notify the other users. Unfortunately, SP2010 removed (or hid it?) it and the options I have are: post a link to the file via an email, or post an self alert of the folder (in which the file is stored). Both the options are not that easy and convenient as the ‘Send immediate alert:’.. do you have any suggestions/methods to bring back the SP2007 feature to SP2010 (presuming that 2010 hid that feature ;-)) Many thanks for your response, have a nice day!


26 Richard Harbridge January 18, 2015 at 9:58 pm

The methods you listed are both effective. Additionally in 2013 there were more features added that improve communication and alerting from following constructs to Delve and the newer experiences.


Leave a Comment