Hands-on With Microsoft’s New Document Connection Tool


In my article Macs in the Enterprise: A Firsthand Tale, I mentioned the hardship I was having dealing with editing documents directly from a SharePoint site.

As a result, I can only perform the most basic of tasks. I can upload and approve documents, but I can’t edit a document directly on the server as I can if I’m accessing the library on Internet Explorer and a Microsoft SharePoint-compatible application. It’s kind of a pain downloading and re-uploading documents when the changes are relatively minor. Later this year, Microsoft is planning on adding the ability for Office 2008 to interact directly with SharePoint, so that might help.

That functionality was part of the recently-released Service Pack 2 for Office 2008. Specifically, you can now check out, edit, and check in documents directly on a SharePoint site. I had a few moments today to test it out and here’s my report from an hour or so of testing.

Before I get too far into the SharePoint tools, I wanted to talk about the speed increases. I have a 2006 MacBook with 2GB of RAM. Even running the latest version of Office 2008, my load times were fairly long. I’ve noticed a significant improvement with SP2. I didn’t do any time tests, but they feel about half what they were. They certainly patched in more snappy.

Without getting into the PC/Mac debate too much, I’ll just say how Microsoft (s msft) has integrated SharePoint within Office 2007 for the PC is amazing — I can even launch workflows on documents. The Document Connection Tool, however, earns an enthusiastic “Eh, well, it’s not bad.” Granted, I can finally edit a document on the site without jumping through a lot of hoops, I still can’t manage workflows and approve documents for publication. It’s not a big omission; I can do those just fine from the browser.

While the Document Connection Tool is a standalone program, you can access it from the File menu in Word and PowerPoint (oddly, I did not see the option in Excel).


The Open From Document Connection Screen

The first time you launch the program, you’ll be greated with a blank window. Choose “Connect to a SharePoint Site…”

crump_Microsoft Document ConnectionScreenSnapz001

A blank Document Connection Screen

Enter in your SharePoint info.

crump_Microsoft Document ConnectionScreenSnapz003

Entering in your SharePoint information

You can also connect to an Office Live Workspace (an online collaboration tool similar to, but not exactly like, Google Docs). Regardless of which you connect to, you’ll manage your documents in this screen (for Corporate Security reasons, I’m showing the connection to my personal Office Live Workspace, not my company’s SharePoint site).

Microsoft Document ConnectionScreenSnapz001

Managing Documents

You manage documents in either location similarly. The biggest difference is in SharePoint you click “Check Out” to edit a document; in Office Live you click “Edit.” In terms of working with existing workspaces in Office Live, the Document Connection Tool is adequate. When it comes to managing those workspaces, it’s not that great. While I can upload a new document to an Office Live workspace (its version of folders), it doesn’t appear I can create new workspaces or delete documents (the “discard” button is grayed out).

Also, these tools seem to assume you have an Internet connection. There doesn’t appear to be any sort of offline syncing similar to Google Gears — while the press release claims offline document caching, I haven’t seen where the cache files are kept, and the only way I’ve been able to open a cached file is from the Recents menu. However, that’s from testing with Office Live, I didn’t test with my production documents on my SharePoint site.

While the Document Connection Tool is a good first step, there are a few things I’d like to see added: the ability to approve documents and manage workflows on a SharePoint site, and the ability to check out a document from both SharePoint and Office Live for offline editing — or make it clearer where I can find them.



Having same problem mentioned about about subsites disappearing if navigate to another, then having to reenter info.

The lack of syncing between Entourage and sharepoint contacts and, especially, calendar may doom the switch to mac for our office.

Another problem having in browser (since lists don’t even seem to open in Document Connection) is editing in data sheet (option doesn’t exist). Also, cannot Connect to Client or Export to Spreadsheet.

Don Montalvo

Can’t delete a file (even if you have full Sharepoint permissions). Can’t create a folder (only a file, through Microsoft Office Word, etc.). Can’t move a file or folder.
Don Montalvo, TX

Don Montalvo

Can’t delete a file (even if you have full Sharepoint permissions). Can’t create a folder (only a file, through Microsoft Office Word, etc.). Can’t move a file or folder.

Don Montalvo, TX

Jennifer Gianfrancesco

The Delete option in the file menu does not work.

If you type in the address to a sharepoint site such as subsite2 as shown below in the navigation pane if you accidentically click on Site which you may not have Contribute permissions to then Sharepoint looses it connection all together and you can no longer connect to Subsite2. You have to add the connection back in. This is very annoying.

Site — Subsite 1 — Subsite2


MS Sharepoint site, MS Document Connection won’t open site with Kerberos.
If I put in the account and password, it’s fine.
Too bad – looks pretty cool.
Any ideas?



try using capital letters in the username field USERNAME@DOMAINNAME

Ambrose Neville

This is excellent news. I’ve just been trying it out over the last few minutes, and while it yet doesn’t work over Kerberos sign-in where I work, username/password authentication to our Sharepoint installation works just fine.

I can’t find much documentation as to how it works. Presumably it’s WebDAV?

-I’d like to see some of the Sharepoint calendar functionality come in to future versions, but given the name of the app, that may not be the MBU’s intention.

-I’d also like to see a right click contextual menu listing that allows you to copy the path the file for the purposes of emailing its location, or maybe a button to email a link to the file in a new Entourage email.

Still, very much a step in the right direction.


I thought kerberos was supported?

I think you can copy the document path by either going under the edit menu or draging the file to your email.


Same here.
Entourage is using the Kerberos tickets just fine.


It appears the Sharepoint item is only enabled for one of the full versions. I have the student (i.e. cheaper) version of Office for the Mac and the Sharepoint item is grayed out.


Comments are closed.