Error with excel data mining and windows 8.1


  • Hi I found this thread online which is exactly the same issue I am having. Has this problem been resolved?

    "I installed SQL Server 2012 SP1 Data Mining add-in for Excel 2013 64 bit on Windows 8.1 64 bit Enterprise. I then ran "Getting Started" to complete the add-in setup and connect to the SSAS DB. After I opened the "Sample Excel Data" file to test I noticed the "Table Analysis" tab under "TABLE TOOLS" appeared on the ribbon blank (without the text "ANALYZE" on the tab). When I clicked on that tab I was able to see the "Table Analysis Tools" buttons but I keep getting the "Object reference not set to an instance of an object" error message when I try to run any one of them and exiting out of Excel disables the data mining add-in. Is this a known issue and if yes is there a hotfix available? Thank you."

    I've also download the follwing hotfix which hasn't helped 

    Any assistance would be appreciated!


    Thursday, June 26, 2014 11:10 AM

All replies

  • Hi Concatch,

    Which edition of Excel 2013 are you using? The supported editions of Office supported by the SQL Server 2012 SP1 Data Mining Add-ins for Microsoft Office are as follows:

    • Professional
    • Professional Plus
    • Ultimate
    • Enterprise

    Besides, make sure the cube is hosted in a SSAS 2012 instance.


    Mike Yin
    TechNet Community Support

    Thursday, July 03, 2014 6:37 AM
  • Hi Mike,

    I'm using Professional Plus and my SSAS is a 2012 instance...


    Thursday, July 03, 2014 7:43 AM
  • I`ve exactly the same issue.

    Any suggestions?



    Tuesday, January 13, 2015 4:33 PM
  • There is no team at Microsoft that is actively working on the data mining add-ins.

    People who worked on the data mining add-ins have moved to Predixion Software and continue development there.

    I recommend that you install add-ins from Predixion (

    Predixion supports all the latest versions of OS, SQL and Office and has a dedicated support team should you have any questions or run into issues.

    Tatyana Yakushev []

    Tuesday, January 13, 2015 7:11 PM