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
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.
Sunday, December 02, 2012 9:06 PM
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.