DavidOverton.com
This site is my way to share my views and general business and IT information with you about Microsoft, IT solutions for ISVs, technologists and businesses, large and small.  
David Overton's Blog » How to get Companyweb (Windows SharePoint Services v2) to work with Office 2007
How to get Companyweb (Windows SharePoint Services v2) to work with Office 2007

[updated 9th August 2007 to add read/write document registry change]

A few people said this was a showstopper for them in recommneding Office 2007 to their customers so I figured it had to be fixed.  I nixed a huge amount of work from the right stuff blog "Office 2007 File Icons for Windows SharePoint Services 2.0 and SharePoint Portal Server 2003" and the script work from http://blogs.msdn.com/karstenj/archive/2006/01/03/508888.aspx.  The problems were: 1) no icons for files 2) file types not recognised by companyweb 3) downloads could not be opened as the file type was said to be a compressed file 4) could not edit from companyweb

OK, so here is the process.

1. Download the icons from here and put them into folder C:\Program Files\Common Files\Microsoft Shared\web server extensions\60\TEMPLATE\IMAGES\ (read the item on the the right stuff to pick your files)

2. Update the C:\Program Files\Common Files\Microsoft Shared\web server extensions\60\TEMPLATE\XML\docicon.xml file with the information below into the ByExtension section

<Mapping Key="docx" Value="docx.gif" EditText="Microsoft Office Word" OpenControl="SharePoint.OpenDocuments"/>
<Mapping Key="docm" Value="docm.gif" EditText="Microsoft Office Word" OpenControl="SharePoint.OpenDocuments"/>
<Mapping Key="dotx" Value="dotx.gif" EditText="Microsoft Office Word" OpenControl="SharePoint.OpenDocuments"/>
<Mapping Key="dotm" Value="dotm.gif" EditText="Microsoft Office Word" OpenControl="SharePoint.OpenDocuments"/>
<Mapping Key="xlsx" Value="xlsx.gif" EditText="Microsoft Office Excel" OpenControl="SharePoint.OpenDocuments"/>
<Mapping Key="xlsm" Value="xlsm.gif" EditText="Microsoft Office Excel" OpenControl="SharePoint.OpenDocuments"/>
<Mapping Key="xltx" Value="xltx.gif" EditText="Microsoft Office Excel" OpenControl="SharePoint.OpenDocuments"/>
<Mapping Key="xltm" Value="xltm.gif" EditText="Microsoft Office Excel" OpenControl="SharePoint.OpenDocuments"/>
<Mapping Key="xlsb" Value="xlsb.gif" EditText="Microsoft Office Excel" OpenControl="SharePoint.OpenDocuments"/>
<Mapping Key="xlam" Value="xlam.gif" EditText="Microsoft Office Excel" OpenControl="SharePoint.OpenDocuments"/>
<Mapping Key="pptx" Value="pptx.gif" EditText="Microsoft Office PowerPoint" OpenControl="SharePoint.OpenDocuments"/>
<Mapping Key="pptm" Value="pptm.gif" EditText="Microsoft Office PowerPoint" OpenControl="SharePoint.OpenDocuments"/>
<Mapping Key="potx" Value="potx.gif" EditText="Microsoft Office PowerPoint" OpenControl="SharePoint.OpenDocuments"/>
<Mapping Key="potm" Value="potm.gif" EditText="Microsoft Office PowerPoint" OpenControl="SharePoint.OpenDocuments"/>
<Mapping Key="ppam" Value="ppam.gif" EditText="Microsoft Office PowerPoint" OpenControl="SharePoint.OpenDocuments"/>
<Mapping Key="ppsx" Value="ppsx.gif" EditText="Microsoft Office PowerPoint" OpenControl="SharePoint.OpenDocuments"/>
<Mapping Key="ppsm" Value="ppsm.gif" EditText="Microsoft Office PowerPoint" OpenControl="SharePoint.OpenDocuments"/>

3. Update the metabase MIME types by running the following script (copy it to a text file called update_mime.vbs and then double click on it - ONCE):

'This script adds the necessary Office 2007 MIME types to an IIS Server.
'To use this script, just double-click or execute it from a command line.
'Running this script multiple times results in multiple entries in the IIS MimeMap.

Dim MimeMapObj, MimeMapArray, MimeTypesToAddArray, WshShell, oExec
Const ADS_PROPERTY_UPDATE = 2

'Set the MIME types to be added
' MimeTypesToAddArray = Array(".manifest", "application/manifest", _
' ".xaml", "application/xaml+xml", ".application", "application/x-ms-application", ".deploy", "application/octet-stream", _
' ".xbap", "application/x-ms-xbap")
MimeTypesToAddArray = Array( _
".docm","application/vnd.ms-word.document.macroEnabled.12" , _
".docx","application/vnd.openxmlformats-officedocument.wordprocessingml.document" , _
".dotm","application/vnd.ms-word.template.macroEnabled.12" , _
".dotx","application/vnd.openxmlformats-officedocument.wordprocessingml.template" , _
".potm","application/vnd.ms-powerpoint.template.macroEnabled.12" , _
".potx","application/vnd.openxmlformats-officedocument.presentationml.template" , _
".ppam","application/vnd.ms-powerpoint.addin.macroEnabled.12" , _
".ppsm","application/vnd.ms-powerpoint.slideshow.macroEnabled.12" , _
".ppsx","application/vnd.openxmlformats-officedocument.presentationml.slideshow" , _
".pptm","application/vnd.ms-powerpoint.presentation.macroEnabled.12" , _
".pptx","application/vnd.openxmlformats-officedocument.presentationml.presentation" , _
".xlam","application/vnd.ms-excel.addin.macroEnabled.12" , _
".xlsb","application/vnd.ms-excel.sheet.binary.macroEnabled.12" , _
".xlsm","application/vnd.ms-excel.sheet.macroEnabled.12" , _
".xlsx","application/vnd.openxmlformats-officedocument.spreadsheetml.sheet" , _
".xltm","application/vnd.ms-excel.template.macroEnabled.12" , _
".xltx","application/vnd.openxmlformats-officedocument.spreadsheetml.template" _
)

'Get the mimemap object
Set MimeMapObj = GetObject("IIS://LocalHost/MimeMap")

'Call AddMimeType for every pair of extension/MIME type
For counter = 0 to UBound(MimeTypesToAddArray) Step 2
AddMimeType MimeTypesToAddArray(counter), MimeTypesToAddArray(counter+1)
Next

'Create a Shell object
Set WshShell = CreateObject("WScript.Shell")

'Stop and Start the IIS Service
Set oExec = WshShell.Exec("net stop w3svc")
Do While oExec.Status = 0
WScript.Sleep 100
Loop

Set oExec = WshShell.Exec("net start w3svc")
Do While oExec.Status = 0
WScript.Sleep 100
Loop

Set oExec = Nothing

'Report status to user
WScript.Echo "SharePoint Mime Types have been added."

'AddMimeType Sub
Sub AddMimeType (Ext, MType)

'Get the mappings from the MimeMap property.
MimeMapArray = MimeMapObj.GetEx("MimeMap")

' Add a new mapping.
i = UBound(MimeMapArray) + 1
Redim Preserve MimeMapArray(i)
Set MimeMapArray(i) = CreateObject("MimeMap")
MimeMapArray(i).Extension = Ext
MimeMapArray(i).MimeType = MType
MimeMapObj.PutEx ADS_PROPERTY_UPDATE, "MimeMap", MimeMapArray
MimeMapObj.SetInfo
End Sub

that did it for me :-)

[updated]

Well, it almost did, in fact, when you tried to open a file by clicking on it, you only got a read only version.  Reading the KB article http://support.microsoft.com/kb/870853 I discovered this was deliberate and I changed it a bit for Office 2007 and now the following command run from an ELEVATED command prompt on the client will work.  You can also set Group Policy on the server to set this key too (just remember to change the 11 to a 12 if reading the KB article).

reg add HKCU\Software\Microsoft\Office\12.0\Common\Internet /v OpenDocumentsReadWriteWhileBrowsing /t REG_DWORD /d 01

 

ttfn

David

 

Posted Tue, Mar 13 2007 12:01 AM by David Overton
Filed under: , , , , , , , , , , ,

Comments

Vijay Singh Riyait wrote re: How to get Companyweb (Windows SharePoint Services v2) to work with Office 2007
on Tue, Mar 13 2007 10:12 AM

This works perfectly for me and will make a big difference, so thanks for finding a solution to that, much appreciated. I can't now see any reason not to recommend Vista in a SBS 2003 environment.

iQubed Blog » Blog Archive » Sharepoint Services v2, Office 2007 and SBS - it does work wrote iQubed Blog &raquo; Blog Archive &raquo; Sharepoint Services v2, Office 2007 and SBS - it does work
on Tue, Mar 13 2007 12:49 PM
Brian Jones: Open XML Formats wrote Get CompanyWeb to work with new extensions
on Tue, Mar 13 2007 5:52 PM

David Overton has a blog post describing how folks with SBS can make a few updates so they get the new

Office Rocker! wrote yet more roadshow questions
on Thu, Mar 15 2007 7:34 PM

Technet will windows meeting space have clients written for xp machines, or will it not be a useable

Office Rocker! wrote Yet more questions from the roadshow
on Thu, Mar 15 2007 7:42 PM

Technet will windows meeting space have clients written for xp machines, or will it not be a useable

Matt Frye wrote re: How to get Companyweb (Windows SharePoint Services v2) to work with Office 2007
on Mon, Mar 19 2007 5:18 PM

Does this fix

Companyweb saying that my address book is not compatable if i have Outlook 2007 installed ?

Mike Wolfe wrote re: How to get Companyweb (Windows SharePoint Services v2) to work with Office 2007
on Thu, Apr 5 2007 10:57 PM

Dave

Thanks for the excellent effort!  I am on a SBS2k3 SP2 server, and (after 2 server re-boots [for other reasons] over a few days)sharepoint now recognizes and interfaces with my Office 2k7 Ultimate stuff EXCEPT for the following anomalies:

1) AT first it didn't work, then I did a re-boot, and still not working, but the next day I tried again and it worked (so I think it takes some kind of SQL housekeeping before it really takes??)

2) My big problem right now is that all the Office 2k7 documents are set as Read-Only, so it wants me to give them a new name every time I edit them.  This is a BIG puzzle for me -  I have gone to Control Panel | Add / RTemove Programs | Ms Office 2k7 Ultimate | Change and set the Sharepoint stuff under Tools to Run All From My Computer.

Still Read-Only(??)  Do you have any idea why??

3) I also use Visio a  lot - I can muddle through the Icon portion of the update OK, But I have no Idea what to do about MIME Types for Visio -  would you be able to post that info in a follow up please????

Thanks Dave

Mike Wolfe

[email protected]

Vlad Mazek - Vladville Blog » Blog Archive » Office 2007 MIME types for Apache wrote Vlad Mazek - Vladville Blog &raquo; Blog Archive &raquo; Office 2007 MIME types for Apache
on Mon, Apr 9 2007 12:47 PM
Mike Wolfe wrote re: How to get Companyweb (Windows SharePoint Services v2) to work with Office 2007
on Thu, Apr 12 2007 9:42 PM

Dave

Re:My Apr 5 Query

Without doing anything further, my Visio docs are being handled correctly, so thats a non-issue now.

Re the Read Only anomaly I have passed the issue on to a local Microsoft Tech Rep who has posted it internally at Msoft, so maybe that will kick start a solution

Tx

Mike

WSS 2.0 Office 2007 Support for TFS « Moments in the Life of a Samster wrote WSS 2.0 Office 2007 Support for TFS &laquo; Moments in the Life of a Samster
on Tue, Apr 17 2007 11:41 PM
MEC Admin wrote re: How to get Companyweb (Windows SharePoint Services v2) to work with Office 2007
on Wed, May 2 2007 6:28 AM
Thanks for your great efforts. Works great!
Richards Infrastructure Blog wrote Office 2007 icons and correct functioning in SharePoint 2003
on Wed, May 23 2007 5:12 PM
JIRA: Moodle wrote [MDL-9940] filelib.php should be updated for new MS Office 2007 formats
on Sat, Jun 2 2007 1:46 PM
Since original posting, I have found more information on the mime-types of the new Office 2007 which *may* be relevant to the details of this issue/fix Office 2007 Icons: http://www.therightstuff.de/2006/12/16/Office+2007+File+Icons+For+Windows+Sha..
the foremind » Blog Archive » Office 2007 document types and webservers wrote the foremind &raquo; Blog Archive &raquo; Office 2007 document types and webservers
on Fri, Jun 15 2007 1:20 AM

Pingback from  the foremind  &raquo; Blog Archive   &raquo; Office 2007 document types and webservers

Lee Edge wrote re: How to get Companyweb (Windows SharePoint Services v2) to work with Office 2007
on Thu, Jul 12 2007 1:22 PM

Hi,

Nobody has mentioned about the fact that when you open a word file in 2007 from companyweb it prompts you with a box similar to if you are downloading a file whereas previously it would just go straight into word.  Anybody got a fix for this?

Regards

Lee Edge

David Overton wrote re: How to get Companyweb (Windows SharePoint Services v2) to work with Office 2007
on Thu, Jul 12 2007 1:51 PM

Lee, have you done everything posted above - it should add icons and also enable you to download files.  It sounds like the MIME types have not updated properly.  Check to see if they have and also try a IIS restart.

thanks

David

Lee Edge wrote re: How to get Companyweb (Windows SharePoint Services v2) to work with Office 2007
on Fri, Jul 13 2007 12:21 PM

Hi,

Yes followed all the instructions, and all seems fine.  I can download and open the files and save them back it's just frustrating that when you click on the word file you are prompted to open it - are you not seeing this behaviour?

Thanks

Lee

David Overton wrote re: How to get Companyweb (Windows SharePoint Services v2) to work with Office 2007
on Fri, Jul 13 2007 12:57 PM

Lee,

if you look in IIS, is the DOCX type a known mime type - if yes, then this should not be happening.  If no, then the routine to set hte MIME types is failing.  Check for the actual site you are looking at.

thanks

David

TrackBack wrote http://spyjournal.biz/techtips/2007/03/windows-sharepoint-services-2-and.html
on Tue, Jul 24 2007 7:23 AM
Rich Lusk wrote re: How to get Companyweb (Windows SharePoint Services v2) to work with Office 2007
on Mon, Jul 30 2007 4:52 PM

Lee,

In order to get the download prompt to go away you need to go to Windows Explorer, click Tools, Folder Options, and then click the File Types tab.  Click the extension .docx and click the Advanced button.  Uncheck the box "Confirm open after download".  You need to follow these steps for each Office extension such as .doc, .xls, .ppt, etc. to make sure you don't the prompt for other Office files as well.  Hope that helps!

Rich Lusk wrote re: How to get Companyweb (Windows SharePoint Services v2) to work with Office 2007
on Tue, Jul 31 2007 5:41 PM

Actually Lee is right.  After I did the procedure mentioned above I received the same message whenever I tried to edit an Office document from the Companyweb.  I found out the solution I gave doesn't work anymore nor does it work when using SharePoint Version 3.  The solution that does work now is to add the companyweb to the Trusted Websites in Internet Explorer.

David Overton wrote re: How to get Companyweb (Windows SharePoint Services v2) to work with Office 2007
on Tue, Jul 31 2007 5:50 PM

OK, I have a web cast coming up on this, so I will re-work the solutions and if I see the same results I will fix it.

thanks

David

Rich wrote re: How to get Companyweb (Windows SharePoint Services v2) to work with Office 2007
on Thu, Aug 2 2007 7:43 PM

David,

I just encountered a similar issue that maybe you can help me with because Microsoft Support doesn't seem to know how to fix it.  I just installed SBS 2K3 R2 for a client and they have Office 2007 on all clients.  I noticed none of the documents in Companyweb have the proper icons.  I did as you suggested above and now icons show up for Office 2007 docs but not for Office 2003 compatible docs.  What should I do?

Thank you for great info above.

Mike wrote re: How to get Companyweb (Windows SharePoint Services v2) to work with Office 2007
on Tue, Aug 7 2007 5:12 PM

I have an Sharepoint 2003 Server and I'm using a client thats running Windows XP SP2, IE7, and Office 2007.  The above configurations work for getting Sharepoint to recognize the new Office 2007 file types, but all of the documents open as Read-Only and will not allow me to edit the file I have open.  Any idea on how to fix this??

David Overton's Blog wrote Slides from todays Webcast on Windows SharePoint Services on SBS (WSS v2 & WSS v3)
on Wed, Aug 8 2007 10:40 AM

Today I did my last Webcast on SBS. It was the 3rd of a 3 parter on SBS. Part 1 was about how to use

David Overton wrote re: How to get Companyweb (Windows SharePoint Services v2) to work with Office 2007
on Thu, Aug 9 2007 8:04 PM

OK, I will be looking at this today...

I'll update a new post and link in once I know more.

ttfn

David Overton wrote re: How to get Companyweb (Windows SharePoint Services v2) to work with Office 2007
on Thu, Aug 9 2007 11:14 PM

Right, the fix is as follows:  To make Office 2007 files read/write you need to run the following command from an elevated cmd prompt:

reg add HKCU\Software\Microsoft\Office\12.0\Common\Internet /v OpenDocumentsReadWriteWhileBrowsing /t REG_DWORD /d 01

that is it.

thanks

The Dúnadan Blog wrote Enabling Office 2007 document mapping and support for Team System Projects in the Sharepoint Portal
on Wed, Sep 26 2007 2:02 AM

While embarking on a project to create DNN modules with Visual Studio Team System developoment lifecycle support, I noticed that the Sharepoint Team Portal that is created for a project uses Offi ...

Mark Maher wrote re: How to get Companyweb (Windows SharePoint Services v2) to work with Office 2007
on Fri, Sep 28 2007 5:57 PM

Hi David,  I have one workstation that can open documents from company web in explorer, but if you try to save back or open a document from within word it cannot open the companyweb folders.  It is workstation related as the same user has no problem from any other machine.  I have reloaded office from scratch with no joy.  I set a drive mapping to general docs as a work around but that can make word crash sometimes on this machine.

BTW:- any way to stop repeated mails on the sbs pop3 connector if an external person sends to one or more internal recipients?

Any Ideas?

How to get Companyweb (Windows SharePoint Services v2) to work with Office 2007 - David Overton’s Blog « Taking it Upwards with SBS - Dale aka Sisyphus’ Weblog wrote How to get Companyweb (Windows SharePoint Services v2) to work with Office 2007 - David Overton&#8217;s Blog &laquo; Taking it Upwards with SBS - Dale aka Sisyphus&#8217; Weblog
on Sun, Oct 28 2007 8:56 PM

Pingback from  How to get Companyweb (Windows SharePoint Services v2) to work with Office 2007 - David Overton&#8217;s Blog &laquo; Taking it Upwards with SBS - Dale aka Sisyphus&#8217; Weblog

TK wrote re: How to get Companyweb (Windows SharePoint Services v2) to work with Office 2007
on Thu, Nov 22 2007 8:20 AM

Works perfectly, thank you very much for your work!

Kelly wrote re: How to get Companyweb (Windows SharePoint Services v2) to work with Office 2007
on Wed, Dec 19 2007 4:36 PM

Still won't display the .xlsx but now instead of getting the default ms icon (icgen.gif?)  I get a missing file icon with a Red X that says ICON.

It's looking for companyweb/.../xlsx.gif

I verified that xlsx.gif is in C:\Program Files\Common Files\Microsoft Shared\web server extensions\60\TEMPLATE\IMAGES

still not displaying the excel 2007 icon, even though it's there and I can manually double click on it and it displays.

help?

Thanks!

David Overton wrote re: How to get Companyweb (Windows SharePoint Services v2) to work with Office 2007
on Wed, Dec 19 2007 4:46 PM

Kelly,

does everything else now work?  If so, then there is a problem reading the gif file.  1st check that it has permissions that means that the IIS account can read the file and also check that it is not in a subdirectory or anything simple like that.

It is also worth stopping and starting IIS Admin to be sure.

thanks

David

Tom wrote re: How to get Companyweb (Windows SharePoint Services v2) to work with Office 2007
on Wed, Jan 23 2008 7:29 PM

You said "You can also set Group Policy on the server to set this key too (just remember to change the 11 to a 12 if reading the KB article).

reg add HKCU\Software\Microsoft\Office\12.0\Common\Internet /v OpenDocumentsReadWriteWhileBrowsing /t REG_DWORD /d 01

"

My question is how?  Thanksin advance.

Richard Tubb wrote re: How to get Companyweb (Windows SharePoint Services v2) to work with Office 2007
on Tue, Apr 29 2008 7:38 PM

David - huge thanks for this article, saved me mucho time drawing together all the relevant bits of information myself! All I'd add to the above is:-

1. When the article refers to copying files to C:\Program Files\Common Files\Microsoft Shared\web server extensions\60, do this on the server - not the client's workstations experiencing the issue.

2. Make sure to copy the relevant .gif files from one of the folders (gif-dark, gif-light) into C:\Program Files\Common Files\Microsoft Shared\web server extensions\60\TEMPLATE\IMAGES\ to make sure 2007 (.docx, .xlsx, etc) files show a correct icon within companyweb.

3. Also, stop/restart IISAdmin on the server after these changes to make them "stick".

Keep up the great work David, really appreciate articles like this!

Cheers,

Ric.

John Bennett wrote re: How to get Companyweb (Windows SharePoint Services v2) to work with Office 2007
on Mon, Jun 23 2008 4:08 PM

Thanks for an excellent article David. It worked on my first try, and we finally have our Office 2007 users able to edit and save to our Sharepoint site on SBS 2003.

One side note: I actually prefer the read-only functionaiity when clicking on Sharepoint document. We can always edit by clicking the local menu on the document name and choosing "Edit in Microsoft Word" (or other associated Office program).

Mobile Rumors wrote Mobile Rumors
on Tue, Jul 1 2008 4:38 PM

If you do the same search via google. com, you get search results, but no line score. You can get the score via a PC by using google. com/ m. I don’ t know what it does if a game is in progress, but for that I like the MLB site better anyway, as it has

ASP Net Web Development wrote re: How to get Companyweb (Windows SharePoint Services v2) to work with Office 2007
on Tue, Sep 2 2008 1:04 PM

Terrific post... nice work... thanks for sharing...

kreditrechner wrote re: How to get Companyweb (Windows SharePoint Services v2) to work with Office 2007
on Sat, Nov 1 2008 8:23 AM

  does everything else now work?  If so, then there is a problem reading the gif file.  1st check that it has permissions that means that the IIS account can read the file and also check that it is not in a subdirectory or anything simple like that.  

Holger onecker wrote re: How to get Companyweb (Windows SharePoint Services v2) to work with Office 2007
on Mon, Nov 17 2008 6:18 PM

Excellent work, exactly what I was searching and it worked 100%

JohnnyD wrote re: How to get Companyweb (Windows SharePoint Services v2) to work with Office 2007
on Sat, Oct 10 2009 1:49 PM

I've done this  but now when I click 'browse...' to upload any file, IE crashes. It does this as soon as I click on the button. I followed the instructions to the letter and have double-checked all the MIME types and xml files are correct. I've also restarted IIS twice.

Has anyone else experienced this?

Yan wrote re: How to get Companyweb (Windows SharePoint Services v2) to work with Office 2007
on Fri, Feb 5 2010 11:21 PM

@Kelly.

The images you download have the gifs in subfolders.  Make sure to move them out into the root of \images.

Also not sure why there where a bunch of different versions of the icon in there.  I suppose this was just an icon pack of some kind.

Worked great after I figured that out ;)

thanks

Office Resource Kit Blog wrote Register Office 2007 file format MIME types on servers
on Wed, Oct 6 2010 3:27 AM

In order for servers to recognize the new file formats in the 2007 Office system, you will need to register

Add a Comment

(required)
(optional)
(required)  
Remember Me?

(c)David Overton 2006-23