Updated: July 13, 2020 (August 22, 2011)

Office 2010 Versus Office Web Apps

Wes Miller analyzes and writes about Microsoft’s security, identity management, and systems management technologies. Before joining Directions on Microsoft, Wes... 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: the Excel Web App supports simultaneous editing (coauthoring) while Excel 2010 does not. This chart shows some key 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

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