Maybe the most significant addition to Microsoft Office 2010 is the addition of Office Web Apps functionality.

The Technical Preview of Office Web Apps was released separately from the Office Technical Preview, so this beta is the first time that the two have been merged publicly.

When released in its final form, Office Web Apps will come in three flavours:

  • A hosted version, powered by SharePoint, for business customers who pay for hosted accounts on Microsoft Online Services
  • A corporate version, which will be hosted on enterprises' own SharePoint servers
  • A consumer version, tied to SkyDrive, Microsoft's free online storage service

The three versions will be largely the same, with some small differences.

The consumer version will have ads as well as features such as publishing to third party blogs, while the other two versions will include enterprise level tools such as backup and restore, version control and IT control over how Web Apps are used.

In the beta, only the hosted SharePoint version is available, the Technical Preview consumer version on SkyDrive won't be updated until the second half of 2010. I reviewed the SharePoint version on a site provided and hosted by Microsoft.

The site did not allow for creating new documents, so I was not able to test that feature, but I was able to edit existing documents. Presumably, the editing features for document creation will be the same as those available for editing existing documents.

Office Web Apps is composed of four applications: Excel, PowerPoint, Word and OneNote. In the beta, as in the Technical Preview, Excel and PowerPoint are more complete, while Word and OneNote are still works in progress.

Excel 2010 vs Excel Web App 1

The Web version of Excel (on the right), looks much like the client version of Excel (on the left). However, the Web version is pretty underpowered compared to its client version.

See the offline Excel in more detail below...

Excel 2010 vs Excel Web App 2

... followed by the Excel Web App below that:

Excel 2010 vs Excel Web App 3

The Office Web Apps look very much like the equivalent client versions, and are far more polished-looking than the competing Google Docs applications. They display documents with full fidelity, and the documents look the same online as they do on your PC.

There have been some changes since the Technical Preview release, although no major ones.

You can now edit documents in Word, something not previously possible, and you get the control you would expect over fonts, text size and so on. You also get spell-checking and the ability to insert and handle tables. But there's not a lot beyond that - no search and replace, no header or footer handling, no graphics handling, no page layout controls, no markup... in fact, there is very little else at this point.

The OneNote Web App, which wasn't available during the Technical Preview is now available, but as with Word, you can only do viewing and rudimentary editing. Microsoft says that both the Word and OneNote Web Apps are still in a relatively early stage of development and will be beefed up in future betas.

I found that little, if anything, changed in the Excel and PowerPoint Web Apps between the Technical Preview and beta, and Microsoft says that both apps are now feature complete. That's a surprise, given how underpowered both are compared to their client versions.

In Excel, for example, you can't add charts to your documents, although if you've added a chart in the client version, the chart will display and you can edit it.

And in PowerPoint, you can't add backgrounds to presentations or animations between slides. Given that Microsoft needs to fend off Google Docs, it's hard to understand why the company left out these basic and important features.

The beta does show how compelling Office Web Apps can be when paired with SharePoint. SharePoint displays all shared documents of a team, workgroup or organisation, and lets you lock documents so that only one person can work on them at a time, or allow multiple people to work on them together. It also lets you build workflows for individual documents - for collecting feedback, automatically routing them to approvers and so on.

It's not clear, though, whether in the public beta these features will be available to anyone beyond those who have access to a site created by Microsoft, as I did.

As with the Technical Preview, something very important is missing in the beta: automatic synchronisation of files between the web-based version of Office and the client version. When you work on the web version, those files live on the web, not your local PC. When you work on the client version, they live on your local PC, not the web. You can save files between the versions - for example, when you have a file open on your local PC, you can save it to the web, and when you have a file open on the web, you can save it to your local PC.

But unlike in Google Docs, there is no automatic synchronisation of files. This can potentially be very confusing, because you can end up with different versions of the same document in different locations, and so you might overwrite newer documents with older ones, or simply not know which is the latest version.

Microsoft already has the technology to do automatic synchronisation built into its free Live Mesh and Live Sync products. So it's baffling that the company didn't include that feature in Office, especially because its biggest competitor, Google, includes it in Google Docs.


As the public, consumer version of Office Web Apps is not part of the beta, we can't yet give a full verdict on Microsoft Office 2010 Web Apps, but as soon as one becomes available we'll update this review. In the meantime it's clear that Office Web Apps is going to change the way all of us use Office.