none
Error with excel data mining and windows 8.1

    Question

  • 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

    http://hotfixv4.microsoft.com/SQL%20Server%202012/sp1/SQLServer2012_SP1_CU7_2894115_11_0_3393_/11.0.3393.0/free/470544_intl_x64_zip.exe 

    Any assistance would be appreciated!


    Concatch

    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.

    Regards,


    Mike Yin
    TechNet Community Support

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

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



    Concatch

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

    Any suggestions?

    Thanks

    Jose

    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 (https://www.predixionsoftware.com/)

    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 [PredixionSoftware.com]

    Tuesday, January 13, 2015 7:11 PM
    Answerer