Help! I can't install Data Mining Add-ins RRS feed

  • Question

  • I use "MS 365 Apps for enterprise" excel x64 bit but when I install data mining add-ins it's not work, "Setup is missing prerequisites"
    Wednesday, March 10, 2021 4:27 AM

All replies

  • The Data Mining Add-In for Microsoft Office provides you with a way to leverage the power of Analysis Services from within the familiar Excel interface. With the Data Mining Add-In, you can utilize powerful SQL Server Analysis algorithms to find data patterns, uncover hidden relationships, develop data-based predictions, and perform many more complex analyses.

    In this chapter, you discover some of the ways you can use this robust analysis tool to develop analytics and reporting that would have been previously impossible with vanilla Excel.

    Installing and Activating the Data Mining Add-In
    Open Excel and look for a Data Mining tab on the Ribbon. If you see one, the Data Mining Add-In is already activated. If you don’t see the tab, you have to download and install it yourself.

    Downloading the Data Mining Add-In
    Type Excel Data Mining Add-In in your favorite search engine to find the free installation package. Note that Microsoft offers versions for SQL Server 2008 and SQL Server 2012. Be sure to download the version that matches the version of SQL Server your organization is using.

    After it is installed, follow these steps to activate the add-in:

    Choose File → Options.
    Select the Add-Ins option on the left, and select COM Add-Ins from the Manage drop-down menu. Click Go.
    Select SQLServer.DMClientXLAddIn and SQLServer.DMXLAddIn 


    Wednesday, March 10, 2021 11:45 AM
  • Please These are some steps for resolving you problem listed below.

    Step 1: Download Microsoft SQL Server Data Mining Add-ins for Microsoft Office.

    Step 2: Insert the following entry in the Windows registry {.reg file here but use at your own risk}

    Step 3: Proceed with installation which now shouldn’t complain about missing Excel 2010/2013/16 

    Now you can use your SQL Server Data Mining Add-ins...

    these are some instruction help you ...

    Tuesday, March 16, 2021 9:16 AM
  • This is really helpful. Thanks for sharing.
    Thursday, March 18, 2021 6:41 AM
  • You need to go for this...
    Thursday, March 18, 2021 11:50 AM
  • Thanks a lot, it helped me a lot too!
    Tuesday, March 23, 2021 4:49 PM
  • Yo tambien tenia el mismo problema. Gracias, saludos. 

    Wednesday, March 24, 2021 3:39 PM
  • Yo tambien tenia el mismo problema.

    Gracias, saludos

    Wednesday, March 24, 2021 3:42 PM