Microsoft Dynamics AX Support

This blog contains posts by the Microsoft Dynamics AX Support teams Worldwide

Microsoft Dynamics AX 2012 Office Addins tab does not appear in Microsoft Excel 2007 or Word 2007 on a 64bit Windows system

Microsoft Dynamics AX 2012 Office Addins tab does not appear in Microsoft Excel 2007 or Word 2007 on a 64bit Windows system

Rate This
  • Comments 4

We came across several issues recently where we have successfully installed the AX 2012 office addins, but the add-ins tab, DynamicsAX, does not appear in Excel or Word 2007, which is running on Windows Server 2008 R2


This is a known issue in general and is described in one of our earlier posts http://blogs.msdn.com/b/axsupport/archive/2011/11/30/dynamics-ax-2012-office-add-ins-and-office-2007.aspx and the fix is described in KB976811.

 

Analysis:

The fix has two stages as described in the KB article:
(1) Either install Microsoft Office 2007 hotfix 976811 or upgrade to Microsoft Office 2007 Service Pack 3, and


(2) Create a registry reg_dword key called EnableLocalMachineVSTO with value 0x1 under HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\12.0\Common\General\

 

Cause:

However what the KB article does not mention is that on a 64-bit machine the registry path would be HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft\Office\12.0\Common\General as Office 2007 is a 32bit application (the article was written in good old Windows XP 32bit days)

 


So in summary for the issues we encountered, we were able to enable the Office addins on a computer running 64bit Windows Vista/7/Server 2008/Server 2008 R2, by following of the following resolution paths (A) or (B):

 

Resolution:

(A) If you have Excel/Word 2007 SP3 installed than all you need to do is follow through KB976811 and create the registry key, EnableLocalMachineVSTO,  under this path instead: HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft\Office\12.0\Common\General

Then Run Excel or Word and enable the AX 2012 COM add-ins

OR


(B)

(i) If you are running Excel/Word 2007 SP2 or earlier than install hotfix KB976811

(ii) Than follow through KB976811 to create the registry key, EnableLocalMachineVSTO,  but create it under HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft\Office\12.0\Common\General

(iii) Then Run Excel or Word and enable the COM add-ins

 

Further  Information 

You may find that the addins tab disappears each time you load Excel or Word 2007. This is controlled by the registry key LoadBehaviour. The default value is 0, change it to 3 to make it persist. For example on a 64bit computer the LoadBehaviour key for addins in Excel are under:

HKLM\Software\Wow6432Node\Microsoft\Office\Excel\Addins\Microsoft.Dynamics.AX.Framework.OfficeAddin.Excel

 

 

 

 

Leave a Comment
  • Please add 7 and 5 and type the answer here:
  • Post
  • Great information. I'm glad this is posted somewhere.

    With regards to Dynamics AX 2012 working with various versions of Office... I put some information about using Dynamics AX 2012 with Office 365 on my blog:

    blogs.msdn.com/.../can-dynamics-ax-2012-work-with-office-365.aspx

  • On Windows 7 64 & 32 bit running Office 2010 you may also need to upgrade App Fabric (KB2654431) - this fixes an issue where the user has to be a local admin to control the add-in

  • I cannot find any resources how to do my data migration ..

    I have products with variants I completed all work with Excel Addin " Was not Easy Though " now I am stuck with how to define configration size and color and release variants  ..

  • Adrain try this URL - mbs2.microsoft.com/.../KBDisplay.aspx

Page 1 of 1 (4 items)