How to enable the “Edit in Microsoft Office XXXXX” feature for Office 2007 documents

If you have documents stored in WSS 2.0 that were created with the Office 2007 suite you will notice there is no “Edit in Office Word/Excel/PowerPoint” menu item on the document context menu.  For example, if the document was created using Microsoft Office Word 2007, there would be no “Edit in Microsoft Office Word” menu item.  Users are required to download the document to their desktop, make changes, and upload the document again.

For the first time Microsoft will have file extensions with more than 3 characters.  The well known .doc, .xls and .ppt file extensions are no longer used.  The new file extensions for Office 2007 documents are:

Microsoft Office Word 2007:

·         Word Document (.docx) - Default format

·         Word Macro-enabled Document (.docm)

·         Word Template (.dotx)

·         Word Macro-enabled Document Template (.dotm)

Microsoft Office Excel 2007:

·         Excel Workbook (.xlsx) - Default format

·         Excel Macro-enabled Workbook (.xlsm)

·         Excel Template (.xltx)

·         Excel Macro-enabled Workbook Template (.xltm)

·         Excel Binary Workbook (.xlsb)

·         Excel Add-in (.xlam)

Microsoft Office PowerPoint 2007:

·         PowerPoint Presentation (.pptx) - Default format

·         PowerPoint Macro-enabled Presentation (.pptm)

·         PowerPoint Slide Show (.ppsx)

·         PowerPoint Macro-enabled Slide Show (.ppsx)

·         PowerPoint Template (.potx)

·         PowerPoint Macro-enabled Presentation Template (.potm)

·         PowerPoint Add-in (.ppam)

It is possible to customize WSS 2.0 to enable this menu item for Office 2007 documents.   For example, if you would like to enable the same “Edit in Microsoft Office XXXXX” feature for Office 2007 documents follow the step by step instructions below.

Follow the steps below to add this feature for Microsoft Office Word 2007 documents:

1.       Edit the Docicon.xml file to include the .docx, .docm, dotx, and .dotm file name extensions.  To do so:

a.       Start Notepad, and then open the Docicon.xml file. The Docicon.xml file is located in the following folder on the server:          Drive:\Program Files\Common Files\Microsoft Shared\Web server extensions\60\Template\Xml    

b.      In the <ByExtension> section of the Docicon.xml file, add the following entries:

<Mapping Key="docx" Value="icdoc.gif" EditText="Microsoft Office Word" OpenControl="SharePoint.OpenDocuments"/>

<Mapping Key="docm" Value="icdoc.gif" EditText="Microsoft Office Word" OpenControl="SharePoint.OpenDocuments"/>

<Mapping Key="dotx" Value="icdot.gif" EditText="Microsoft Office Word" OpenControl="SharePoint.OpenDocuments"/>

<Mapping Key="dotm" Value="icdot.gif" EditText="Microsoft Office Word" OpenControl="SharePoint.OpenDocuments"/>

d.      On the File menu, click Save, and then quit Notepad.

Follow the steps below to add this feature for Microsoft Office Powerpoint 2007 documents:

1.       Edit the Docicon.xml file to include the .pptx, pptm, potx, and potm file name extensions. To do so:

a.       Start Notepad, and then open the Docicon.xml file. The Docicon.xml file is located in the following folder on the server:          Drive:\Program Files\Common Files\Microsoft Shared\Web server extensions\60\Template\Xml    

b.      In the <ByExtension> section of the Docicon.xml file, add the following entries:

                                <Mapping Key="potx" Value="icpot.gif" EditText="Microsoft Office PowerPoint" OpenControl="SharePoint.OpenDocuments"/>

<Mapping Key="potm" Value="icpot.gif" EditText="Microsoft Office PowerPoint" OpenControl="SharePoint.OpenDocuments"/>

<Mapping Key="pptx" Value="icppt.gif" EditText="Microsoft Office PowerPoint" OpenControl="SharePoint.OpenDocuments"/>

<Mapping Key="pptm" Value="icppt.gif" EditText="Microsoft Office PowerPoint" OpenControl="SharePoint.OpenDocuments"/>

c.       On the File menu, click Save, and then quit Notepad. 

Follow the steps below to add this feature for Microsoft Office Excel 2007 documents:

1.       Edit the Docicon.xml file to include the .xlsx, .xlsm, .xlsb, .xltx, .xltm, and .xltb file name extensions.  To do so:

d.      Start Notepad, and then open the Docicon.xml file. The Docicon.xml file is located in the following folder on the server:          Drive:\Program Files\Common Files\Microsoft Shared\Web server extensions\60\Template\Xml    

e.      In the <ByExtension> section of the Docicon.xml file, add the following entries:

                                <Mapping Key="xlsx" Value="icxls.gif" EditText="Microsoft Office Excel" OpenControl="SharePoint.OpenDocuments"/>

                                <Mapping Key="xlsb" Value="icxls.gif" EditText="Microsoft Office Excel" OpenControl="SharePoint.OpenDocuments"/>

                                <Mapping Key="xlsm" Value="icxls.gif" EditText="Microsoft Office Excel" OpenControl="SharePoint.OpenDocuments"/>

         <Mapping Key="xltx" Value="icxlt.gif" EditText="Microsoft Office Excel" OpenControl="SharePoint.OpenDocuments"/>

                                <Mapping Key="xltb" Value="icxlt.gif" EditText="Microsoft Office Excel" OpenControl="SharePoint.OpenDocuments"/>

                                <Mapping Key="xltm" Value="icxlt.gif" EditText="Microsoft Office Excel" OpenControl="SharePoint.OpenDocuments"/>

f.        On the File menu, click Save, and then quit Notepad. 

Important Note:  An IISRESET must be performed in order for the changes to take effect.  To do so:

a.       Click Start, and then click Run.

b.      In the Open box, type cmd, and then click OK. 

c.       At the command prompt, type the “iisreset”, and then press ENTER.       

Type exit, and then press ENTER to quit Command Prompt.

In the previous tip at the bottom of this page we showed how to add Adobe Acrobat support to SharePoint™. Additional IFilters are available for other filetypes.

Free IFilters

• Cabinet files (Citeknet)
• Compiled HTML files, CHM (Citeknet)
• Help Files, HLP (Citeknet)
• MHTML documents (Citeknet)
• Compressed files, ZIP  (Citeknet)
• JPEG (AimingTech)
• Corel, WP (Corel)
• MP3 (Meticulus)

Purchase

• AutoCAD, DWG (CAD&Company)
• AutoCAD, DWG (Digital CAD)
• CHM IFilter (IFilterShop)
• MindManager IFilter (IFilterShop)
• Inventor IFilter (IFilterShop)
• WMV/WMA IFilter (IFilterShop)
• SHTML IFilter (IFilterShop)
• DWF IFilter (IFilterShop)
• Msg IFilter (IFilterShop)
• PDF+ IFilter (IFilterShop)
• Zip IFilter (IFilterShop)
• XMP IFilter (IFilterShop)
• StarOffice IFilter (IFilterShop)
• OpenOffice IFilter (IFilterShopv)
• vCard IFilter (IFilterShop)

One of the most common requests is how to add an icon for PDF documents and have PDF documents indexed in SharePoint™ Portal Server 2003. 

PDF Icon Support

Copy this icon (right click, save as) as the filename pdf16.gif in the directory C:\Program Files\Common Files\Microsoft Shared\web server extensions\60\TEMPLATE\IMAGES on the SharePoint™ web server.

Edit the file C:\Program Files\Common Files\Microsoft Shared\web server extensions\60\TEMPLATE\XML\DOCICON.XML and add the line

<Mapping Key="pdf" Value="pdf16.gif"/>

in the <ByExtension> area.

PDF Search Support

Install the IFilter for the PDF files on your index server. You can download the filter at Adobe's Web site (note this is the updated version 6.0 IFilter recently posted).

Add the file extension to your index server by going to your site settings and configure search and indexing. There is an option for "Include file types", select that option and then enter "New File Type" and enter "pdf" as a file extension to index.

You will need to re-index your entire site to capture this change.