Sign in
 
Home20122008 R2200820052000LibraryForums
SQL Server >
> 
> 
Not able to see 'Data Mining' and ' Analysis' tabs in Microsoft Excel 2010 (32 bit) after installing Data Mining Add-In

Answered Not able to see 'Data Mining' and ' Analysis' tabs in Microsoft Excel 2010 (32 bit) after installing Data Mining Add-In

  • Sunday, December 02, 2012 8:39 PM
     
     
    Sign In to Vote
    0

    I just installed 'Data Mining Add-in for Office 2007' to begin learning Data-Mining via Excel 2010. However I am not able to see  'Data Mining' and ' Analysis' tabs in Ribbon in Microsoft Excel 2010 (32 bit) . I went ahead and tried to manually add the Add-ins "SQLSERVER.DMClientXLAddin" and "SQLServer.DMXLAddin" to Active Addins in Excel but they are not getting added to the Add-in list.

    While trying to add these Addins, I see this error :

    "Not Loaded. A runtime error occured during the loading of the COM Add-in"

    I want to use this with SQL Server 2008 which I have already installed on my system.

    I am using .NET framework 3.5.

    Its a 32 bit Windows XP operating system.

    I would really appreciate any quick help on this.

    Thanks !

     

All Replies

  • Sunday, December 02, 2012 9:06 PM
     
     Answered
    Sign In to Vote
    0

    Adding .NET Programmability Support for Excel 2010 worked for me . Here are the steps :

    1. Under Add/Remove Programs, select Office 2010.

    2. Select Change.

    3. In the pop-up, select Add or Remove Features.

    4. Under Microsoft Excel, check to see if .NET Programmability Support is Not Available, and change it to Run from My Computer.

    Thanks

    Ankit