Collaboration in Microsoft Office: Painful but not impossible

Today's Best Tech Deals

Picked by PCWorld's Editors

Top Deals On Great Products

Picked by Techconnect's Editors

Microsoft Office has long been the gold standard for creating, editing, and formatting serious documents. Google Docs and other Web-based competitors, however, have outpaced Office by making it easy to share and coedit documents in real time.

Enter the new Office suites. Released earlier this year, they make up lost ground by letting you collaborate with other people through a mixture of desktop and browser applications. The features are a step in the right direction, but Microsoft’s new take on collaboration ultimately fails to be as easy as it should be.

Whether you’re thinking about purchasing an Office 365 subscription or buying Office 2013 desktop software—or are already using either one—read on to learn about the agony and ecstasy of coediting.

I tested collaboration for Word, Excel, OneNote, and PowerPoint, both with colleagues on an Office 365 Small Business Premium account and with people outside our company who didn’t even have Office 2013.

Collaborating with outsiders

To share a document with collaborators, first you must save it online to SkyDrive.

Through the use of SkyDrive cloud storage and the Office Web Apps, the new Office lets you share and coauthor with anyone inside or outside your organization.

For example, a document creator can invite anyone to view or edit a document in the Word Web App. Go into the File menu and click Share, which brings up options for getting others on board. Basically, you create a sharing link and send it via email or instant messaging, or you can generate email invitations to Outlook contacts you designate. Either way, before creating or sending the link, you must save the document to SkyDrive.

Share work in Word, Excel, or PowerPoint by sending someone a link that authorizes them to view or edit the document.

When the recipient clicks the link, a browser window opens the file in the Word, Excel, OneNote, or PowerPoint Web App. Be aware that even if you’ve sent a link authorizing the recipient to edit the document, the recipient sees the same pop-up message that all Office apps generate when you open any document via email or Internet download, warning that because the Internet can be unsafe, by default you can only read the document. The recipient must click a button to enable editing—an odd step, since you had created a link specifically empowering him or her to edit the document.

You and your designated coauthors can work on the document at the same time, with a couple of limitations. In Word, for example, you and your colleagues can't edit the same paragraph simultaneously. If you try to do so, you'll get a pop-up message to that effect.

When you accept an invitation to coauthor a document, it launches in a Web app in read-only mode, even if you have editing permission.

On top of that, you can’t actually see the work a coauthor has done until that person saves it. You can tell in real time, thankfully, that someone else is working on the document, as the app pops up the names of the coauthors. (Alternatively, click File > Info for a backstage view of who’s currently editing.) If the other editor isn’t signed in to a Microsoft account, he or she will appear as a generic ‘Guest’.

Saved changes don’t appear automatically. Rather, Word notifies you that updates are available, and you must save or click on refresh buttons to see a coauthor’s work. Once you do so, changes appear highlighted in pale green.

Coauthoring works fine even when one person is using the Word Web App and the other is using the desktop app. The same holds true for OneNote, where changes do appear automatically, also highlighted in pale green.

Word, Excel, and PowerPoint 2013 for the desktop let you share documents with coworkers by generating email invitations with either viewing or editing permission.

You cannot coedit in Excel while one person is working in the desktop Excel. If you try, you'll get a message saying the spreadsheet is locked. But you can coauthor in the Excel Web App, which is a lot more limited in functionality. Changes appear automatically only after an author leaves a cell, and since they are not highlighted it isn’t always easy to tell what a coauthor has changed. But the app does indicate when others are actively editing.

Changes are highlighted, after the fact.

Microsoft recommends that PowerPoint coauthors stick to either the desktop or the Web app, not both at the same time. If one person is using the desktop version and the other is working in the browser, changes might not save properly. PowerPoint changes don’t have to be saved, though. Instead, they show up after an editor finishes working with an object, such as an image or text box.

Collaborating with colleagues

The Office 2013 desktop apps show who is working on your document, within an icon at the lower left of the window.

People working at organizations that have signed up for an Office 365 business plan have collaboration tools that aren’t available in the consumer versions. Among other things, Office 365 Small Business Premium and Office 365 Midsize Business provide hosted SharePoint and Lync servers for collaboration and unified communications, respectively.

The process of creating documents and inviting coworkers to share them as either viewers or editors is essentially the same here as it is for consumers. There’s a quirk you should know about, however. By default, when you first accept an invitation to edit a document, Office 365 launches the relevant Web app, even if you have a desktop installation of Office 2013. To coedit in the desktop Word, you must click the Edit in Word button within the Word Web App and wait for the program to launch, a time-consuming extra step.

To keep tabs on a document you’ve been invited to share, click the Follow link in the invitation.

An Office 365 administrator can change this default deep inside the settings for the shared site so that documents launch in the desktop app. It's too bad you can’t opt for either the desktop or the Web app before either one launches.

Also, take note that while you might expect the document you’ve been editing to appear in your SkyDrive Pro workspace automatically, this isn’t the case. Documents by default show up only in the SkyDrive files of their creator.

Followed documents provide links to documents others have shared with you. But you can’t see the list of followed docs from the default SkyDrive Pro screen.

To revisit a document created by a coworker, you have to click a link to the document. One way is to find the email invitation containing that link. An easier route is to follow the shared file by clicking the Follow option in the original invitation. That action puts a link to the document within Followed Documents in the left navigation bar of your SkyDrive Pro workspace, under My Documents.

If you’ve set up a newsfeed in your Office 365 profile, you’ll be notified about changes to documents you’re following. But you have to click Followed Documents to see these files. Microsoft could have made things easier with an interface that showed Followed Documents alongside the user’s documents.

Chatting while collaborating

It isn't obvious how to use instant messaging within a document.

Another major quirk we noticed in Office 365 business environments had to do with chatting. When logged in, I could instant-message a colleague from the Outlook Web App by clicking the People item at the top of the Office 365 home screen. But if I then clicked SkyDrive to work on a document, a window told me to end the IM session, and I couldn't use the Outlook Web App to IM while working on a shared document. Microsoft said this isn't how it's supposed to work.

Lync lets you conference and chat from the desktop.

It turns out that there’s another way to IM in Office 365: You have to launch the Lync desktop application that’s included in the Office 2013 desktop software, and sign in to your account from within Lync. You can then message colleagues who are coediting documents from within the document by clicking their name in the list of active editors.

Or, at least, you can in theory. In our tests, we found that sometimes the IM icon was grayed out even with Lync showing the other party as being present. Clearly, Microsoft has a lot of work to do to make chat effortless for collaborators. It’s difficult to understand the decision to create two chat services that don’t integrate with each other, and having to launch a separate application once you’re logged in to the Web service is annoying. The erratic behavior of Lync is the icing on the cake.

Bottom line on collaboration

Here’s what an invitation to collaborate looks like in the Excel Web App. From here, you can’t coauthor with someone using the desktop Excel.

Microsoft clearly wants to empower people to collaborate on documents, but its new Office suites don't make things easy. The various processes for coauthoring in core apps are confusing. In Word, especially, collaboration is slowed down by the requirement that everyone involved must save or refresh documents to see one another’s changes. This setup contrasts sharply with Google’s word-processing app, which displays changes as users type them.

Document sharing in Office 365 business environments is also needlessly unintuitive, making it hard to find a shared document that you didn’t create, or to chat with a colleague while opening a file. It’s nice that Microsoft is taking steps in the right direction, but so far these are baby steps at best. If coediting is a regular part of your workflow, the new Office enables that, but in fits and starts. Either learn these quirks inside and out so that you can work around them, or consider using Google Apps for Business instead.

Note: When you purchase something after clicking links in our articles, we may earn a small commission. Read our affiliate link policy for more details.
Shop Tech Products at Amazon