Updated: July 10, 2020 (July 19, 2010)

Office 2010 vs. Office Web Apps

As managing vice president, Rob Helm covers Microsoft collaboration and content management. His 25-plus years of experience analyzing Microsoft’s technology... more

Office Web Apps do not offer the same features as the Office 2010 desktop applications. When used in conjunction with a SharePoint 2010 server, Office Web Apps offer browser-based read-write access to Office files stored on that server. In most cases, Office Web Apps offer a subset of Office 2010 features, with one exception: Excel Web App supports simultaneous editing (“coauthoring”) while Excel 2010 does not. This chart shows some differences. A checkmark means the feature is fully supported, and a blank box means the feature is missing. Partial support is noted in the text.

Application	Feature	Desktop	Web App
Excel 2010	Create and edit spreadsheets	Yes	Requires XML-based file format
	Calculate formulas	Yes	Yes
	Sparklines	Yes	View-only
	Pivot Tables and Slicers	Yes	View-only (can filter with Slicers)
	Charts	Yes	View-only
	Cell-locking	Yes	View-only
	Coauthoring	No

Atlas Members have full access

Get access to this and thousands of other unbiased analyses, roadmaps, decision kits, infographics, reference guides, and more, all included with membership. Comprehensive access to the most in-depth and unbiased expertise for Microsoft enterprise decision-making is waiting.

Membership Options

Already have an account? Login Now