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