A close-up look at the new Office Web Apps

A close-up look at the new Office Web Apps

Summary: Microsoft flipped the switch on its new Office Web Apps last Thursday, offering a partial technical preview to a limited set of beta testers and invited guests. I’ve had a couple days to work with the new web-based apps, which are both more and less than I expected. Here’s a hands-on report.

SHARE:

Microsoft flipped the switch on its new Office Web Apps last Thursday, offering a partial technical preview to a limited set of beta testers and invited guests. I’ve had a couple days to work with the new web-based apps, which are both more and less than I expected. Here’s a hands-on report.

Let’s be clear right up front: These are not replacements for the full-fledged Office programs. They are, to use Microsoft’s carefully chosen phrasing, “streamlined versions” of four programs in the full Office suite. Currently, Excel and PowerPoint have the most developed feature sets, allowing users to create new workbooks and presentations, edit existing ones, and share web-based files with other users over the internet. Word offers the ability to open and view documents, but not to edit them or to create new ones. OneNote notebooks, which will be part of the final release, are not supported in any way in this preview.

And while the Office Web Apps are being developed along the same general timeline as the full Office 2010 suite, the publicly available technical previews for Office Web Apps and for Office 2010 are not in sync today. As a result, I made sure to perform tests using both Office 2007 SP2 and Office 2010.

Ultimately, you’ll be able to use Office Web Apps in any of three different configurations, only one of which is available for testing today.

  • Corporate customers who have a SharePoint server and Volume License editions of Microsoft Office will be able to create, open, edit, share, and save documents on a server that is under their control. That’s a huge benefit for companies that are (justifiably) nervous about the idea of putting sensitive internal information on servers not under their own control. This option is not available for testing using the current preview release.
  • Business customers who pay for SharePoint access via hosted accounts at Microsoft Online Services will also have access to Office Web Apps. Although my Windows 7 Inside Out team has a compatible SharePoint account on that service, the web apps preview isn’t available yet (and probably won’t be until sometime after final release).
  • The general public will be able to access the Office Web Apps via a free, ad-supported interface that works in conjunction with Windows Live SkyDrive. This is Microsoft’s online storage service that offers 25 GB of free storage in an ad-supported environment. Files can be stored privately, shared with other individuals, or made public. SkeDrive allows the file owner to assign read or edit permissions. This is the option I tested for this post.

Compared to the desktop versions, the Office Web Apps are most definitely streamlined. An uncharitable observer might even call them crippled. What works? what’s missing? I’ve assembled a screenshot gallery to help you see for yourself. For highlights, click to the next page:

Are Office Web apps good enough to replace desktop programs? -->

 <--Previous page

File viewing and sharing

This is easily the biggest strength of the Office Web Apps. In its press release, Microsoft promised that “Using Office Web Apps you will be able to view your documents seamlessly in the browser with great fidelity,” and they have delivered on that promise. With very minor exceptions, every document I created in Word, Excel, and PowerPoint looked exactly the same in the browser window as it did in the desktop program where I created it. Here, for example, is a PowerPoint presentation uploaded to my SkyDrive storage and viewed in Internet Explorer:

Compare that to the desktop version shown in the gallery here and you’ll be hard-pressed to tell the differences. And the fidelity remained intact when I switched to a Mac and opened the same presentation in Safari 4.0, as shown here:

:

Likewise, charts and PivotTables in Excel looked indistinguishable from the versions saved on the desktop. I was able to use all the controls in data tables and PivotTables to filter, sort, and rearrange data in the browser.

Editing files

That impressive performance begins to break down if you want to create or edit a document with anything more than basic features. Microsoft promised you can “create new documents and do basic editing using the familiar Office interface,” and you should take that basic part seriously. In PowerPoint, for example, you can create new slides with ease and even add SmartArt to create informational graphics and org charts, as I’ve done in the gallery:

But the PowerPoint web app doesn’t offer any tools for changing the formatting of those SmartArt objects. An even more glaring omission is the complete absence of tools for creating transitions between slides or animating objects on a slide (so that you can bring in bullet points one by one to match your narration, for example).

Likewise, the Excel Web App is great for entering text and numbers, but there’s no way to create a chart from those numbers. And if you look at a worksheet that contains a chart, you can’t make any changes to the format of the chart (although you can change the underlying data). Similarly, you can’t create or edit a PivotTable on the web.

The bottom line

The biggest question I had when I heard that Office Web Apps were on the way was whether they would cannibalize sales of Office desktop programs. Based on this preview, there’s little danger of that happening. The web-based programs are ideal for viewing, and performing the most basic editing of text and numbers or for sharing a ready-made workbook or presentation, but for any kind of meaningful formatting or document creation their feature sets are too restricted to be competitive with the desktop versions.

Topics: Microsoft, Cloud, Collaboration, Hardware, Software

Kick off your day with ZDNet's daily email newsletter. It's the freshest tech news and opinion, served hot. Get it.

Talkback

29 comments
Log in or register to join the discussion
  • Looks like 'View and correct', rather than 'Create and maintain'

    Basically, it looks like Office Web Apps is for viewing and minor editing, but not risking breaking Office docs.
    Patanjali
  • Ok... So it's definitely a version 1.0 product.

    Meanwhile, Office 2007 is the 6th version since Windows 95. It's also still a BETA product, not by any means a finished product that's been through the spit and polish machine with years of refinement. Of course, the desktop version will be more robust.

    Give 'em time... They'll get there.
    Wolfie2K3
  • Driving consumers away... Again.

    Again MS demonstrates that the average user simply isn't that important to them by making the "average user" (doesn't have or use sharpoint) the bottom of the function/feature list.

    To me that sounds like they are inviting competition to fill the void.
    No_Ax_to_Grind
    • average user can use the free version..

      "The general public will be able to access the
      Office Web Apps via a free, ad-supported interface
      that works in conjunction with Windows Live
      SkyDrive."

      Average user can use that. Businesses may want to
      host their own version. This will provide an
      alternative to Google Apps who host your web based
      applications for you.
      bmonsterman
      • With very limited functionality

        And that's where MS is falling down when it comes to the non-enterprise user. You don't see other web sites doing that.
        No_Ax_to_Grind
        • What other web sites?

          Like, Google docs? Like that doesn't have limited functionality? What website gives an an office appliction for free with all of the functionality of the desktop version of MS Office professional?
          bmonsterman
          • one site is...

            zoho.com
            Although I haven't used it very much, it does appear to have a lot of options and overall it seems to be quite good and complete, considering it's still in beta.
            mrdt
    • So what do you expect ..

      for them to just give their hard word away? Is that what musicians are doing, spending hours of hard work on their product just so it can be downloaded free of cost? How about book authors, say Dan Brown? Or the movie industry for that matter. Wake up dude. This is commerce
      JonWayn
      • More Correctly

        Commerce? More correctly a "Business Model"
        which if you get it right will create commerce. But if
        you get it wrong then no commerce.

        This is just another MS idiotic idea, they don't want
        to cannibalize their own Office business so they
        provide a half assed alternative, maybe free to some
        customers, but with no useful functionality.

        They won't have to worry about cannibalizing their
        business the others in this business space will
        eventually do it for them. 17% revenue decline in
        the 4th quarter.
        bigpicture
  • Insecure software

    Why does a company need to spend countless tens of thousands on software to create a document???

    This is silly, Open_Source shines and it is the future in the market now since companies are trying to lower license costs and get away from lock in.

    The lethargic MS model is trying to 'jump the shark' so to speak.

    Meanwhile, Open_Source is driving appliance driven architecture and VMware is ruling the Virtual market.

    MS is grasping at anything to hold on to license/patent material.

    Thumbs down.

    Christian_<><
    • Parrot

      You're repeating yourself on everything
      Microsoft centric blog post and it's getting
      old. Microsoft is doing what it's supposed to
      be doing, developing software. The are adding
      a web version of their product to compete with
      Google Apps. I think you're claim that they
      have "jumped the shark" is premature
      considering they still have a stranglehold on
      market share. It also remains to be seen
      whether Software as a service/Cloud computing
      or Virtual Appliances (or neither) will
      dominate the next round of IT.
      bmonsterman
    • Uh, hello?

      When did VMWare start writing open source software?

      And where is the open-source cloud-based productivity suite?
      Ed Bott
      • Hello right back

        "When did VMWare start writing open source software?"

        Did you blink and miss their acquisition of SpringSource?
        VMware now is a leading provider of open source web
        application infrastructure...
        qnetter
        • Oh please...

          Microsoft distributes lots of open source software as well (codeplex.com). The OP's point was about VMWare's virtualization platform. So how much of that is open source? VMWare makes a lot of money selling excellent, not cheap, not open source virtualization software.
          Ed Bott
        • Is that relevant?

          What does SpringSource have to do with Virtual
          Appliances vs Cloud Based Software of a service?
          They have an application framework. What does do
          they have to do with infrastructure?
          bmonsterman
          • Correction

            "Cloud based software as a s service"
            bmonsterman
    • Someone is grasping at anything, all right

      Though I suggest a look in the mirror to see who it is that is grasping at the moment.

      At least you critiqued your own post with a "thums down" at the end, as I do agree with you there. :)
      GuidingLight
  • RE: A close-up look at the new Office Web Apps

    Sorry, wrong place...
    qnetter
  • The best model for MS Office

    While this product is certainly a MS 1.0 release (beta in anyone else's structure), I feel that this may be the best venue for the future of Office.

    It allows a constant upgrade path with cost control rather than an office suite that needs replaced for an unknown (large) cost on an indeterminate schedule.
    aharper@...
    • Availability of Office 2010 for average user

      How CanI Geet the Beta version of Windows 2010 Office free?
      Slapshot173@...