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

 > 

  • Question

  • Question
    Sign in to vote
    21
    Sign in to vote
    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

  • Question
    Sign in to vote
    10
    Sign in to vote

    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 

    Regards,
    Bruce

    • Proposed as answer by Ken Max Tuesday, October 12, 2021 8:14 AM
    Wednesday, March 10, 2021 11:45 AM
    |
  • Question
    Sign in to vote
    1
    Sign in to vote

    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 ...

    • Proposed as answer by 90S Outfits Wednesday, June 1, 2022 1:37 AM
    Tuesday, March 16, 2021 9:16 AM
    |
  • Question
    Sign in to vote
    1
    Sign in to vote
    This is really helpful. Thanks for sharing.
    Thursday, March 18, 2021 6:41 AM
    |
  • Question
    Sign in to vote
    2
    Sign in to vote
    You need to go for this...
    Thursday, March 18, 2021 11:50 AM
    |
  • Question
    Sign in to vote
    1
    Sign in to vote
    Thanks a lot, it helped me a lot too!
    Tuesday, March 23, 2021 4:49 PM
    |
  • Question
    Sign in to vote
    2
    Sign in to vote

    Yo tambien tenia el mismo problema. Gracias, saludos. 

    Wednesday, March 24, 2021 3:39 PM
    |
  • Question
    Sign in to vote
    0
    Sign in to vote

    Yo tambien tenia el mismo problema.

    Gracias, saludos

    Wednesday, March 24, 2021 3:42 PM
    |
  • Question
    Sign in to vote
    0
    Sign in to vote

    Hey,

    Type Excel Data Mining Add-In in a search engine to find the free installation package. Note that Microsoft offers versions for SQL Server2012 & SQL Server 2008. Make sure that you download the version that corresponds to the version of SQL Server that your company uses.

    After installation, perform the following steps to activate the add-in:

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

    Saturday, May 1, 2021 12:40 PM
    |
  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi,

    Great information.

    https://www.sevenmentor.com/machine-learning-course-in-pune.php



    Tuesday, July 6, 2021 8:33 AM
    |
  • Question
    Sign in to vote
    0
    Sign in to vote

    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 

    Regards,
    Bruce

    Thank you!
    Tuesday, July 6, 2021 2:09 PM
    |
  • Question
    Sign in to vote
    0
    Sign in to vote
    Open Excel and look for a Data Mining tab on the Ribbon. If you see one, the Data Mining Add-In is already activated.
    Downloading the Data Mining Add-In
    1. Choose File → Options.
    2. Select the Add-Ins option on the left, and select COM Add-Ins from the Manage drop-down menu.
    3. Select SQLServer.
    Saturday, July 10, 2021 8:05 AM
    |
  • Question
    Sign in to vote
    0
    Sign in to vote
    I was also facing problem for data mining.
    Thanks for your step by step guide. very helpful
    Monday, July 12, 2021 6:42 AM
    |
  • Question
    Sign in to vote
    1
    Sign in to vote
     I am also having the same issue. itprospt.com/ad-account-keeps-locking-out-what-can-you-do/
    • Edited by susanmark Tuesday, July 13, 2021 9:27 AM add a question
    • Proposed as answer by Ken Max Tuesday, October 12, 2021 8:13 AM
    • Unproposed as answer by Ken Max Tuesday, October 12, 2021 8:14 AM
    Monday, July 12, 2021 9:34 AM
    |
  • Question
    Sign in to vote
    0
    Sign in to vote
    Step 1: First of all, Install the Oracle database.
    Step 2: Check the data mining installation.
    Step 3: Enable or disable the data mining option.
    Step 4: You can optionally install sample Oracle databases.
    Step 5: You can optionally install Oracle Data Miner.
    Step 6: You can optionally install the Spreadsheet Add-in.
    Friday, August 13, 2021 5:15 AM
    |
  • Question
    Sign in to vote
    0
    Sign in to vote
    Start by downloading Microsoft SQL Server Data Mining.
    Wednesday, August 18, 2021 6:51 AM
    |
  • Question
    Sign in to vote
    0
    Sign in to vote
    The last time Microsoft released a version for the data mining add-in for Excel was in the 2013 version, so to use this tool in Excel 2016 or 2019 (Office 365) it is necessary that we do a couple of tricks that must be said that they are not supported by Microsoft. One option is to have both versions of Excel 2013 and 2016 installed so that the Excel 2013 DM add-in works partially for Excel 2016 as well. The following trick allows installation in Excel 2016 and later by modifying the computer registry. Download the Microsoft SQL Server 2012 SP4 Data Mining Plug-in for Microsoft® Office . Insert the entry in the Windows registry in the regedit: [HKEY_LOCAL_MACHINE \ SOFTWARE \ Microsoft \ Office \ 16.0 \ Common \ InstallRoot] "Path" = "C: \" Now you can safely install the plugin.
    Wednesday, September 8, 2021 6:57 AM
    |
  • Question
    Sign in to vote
    0
    Sign in to vote
    Here I am, Anthony, and I would like to assist you today. Hope things are going well and you're safe over there.

    Here are some easy steps you can use to install data mining add-in:

    1. At first, download Microsoft® SQL Server® 2012 SP4 Data Mining Add-ins for Microsoft® Office®

    2. Then add the following entry in the Registry Editor

    Computer\HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\15.0\Common\InstallRoot

    3. Proceed the process

    I hope this will help and look forward to seeing positive results.

    Best regards,
    Anthony
    • Edited by Antho_K Friday, September 17, 2021 7:39 AM
    Friday, September 17, 2021 7:36 AM
    |
  • Question
    Sign in to vote
    0
    Sign in to vote
    Thanks for sharing it.
    Tuesday, October 12, 2021 6:43 AM
    |
  • Question
    Sign in to vote
    1
    Sign in to vote
     I am also having the same issue. itprospt.com/ad-account-keeps-locking-out-what-can-you-do/
    I think you should try the solution posted by BruceBanner 

    "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 

    Regards,
    Bruce"

    Tuesday, October 12, 2021 8:15 AM
    |
  • Question
    Sign in to vote
    0
    Sign in to vote

    Helpful Post

    https://www.appslure.com/mobile-app-development-company-dubai-uae/

    Tuesday, October 12, 2021 8:20 AM
    |
  • Question
    Sign in to vote
    0
    Sign in to vote
    It worked out , thanks for your help...
    Saturday, January 8, 2022 9:14 AM
    |
  • Question
    Sign in to vote
    0
    Sign in to vote
    Select File first.

    Then Go to Option. 

    Then Select the Add-Ins Choice on the left, 

    Then Select COM ADD-Ins from Manage drop-down Menu. 

    Then select SQL Server.

     
    Sunday, January 9, 2022 10:47 AM
    |
  • Question
    Sign in to vote
    0
    Sign in to vote
    Select File first.

    Then Go to Option. 

    Then Select the Add-Ins  Choice on the left, 

    Then Select COM ADD-Ins from Manage drop-down Menu. 

    Then select SQL Server.

     

    Hi,

    thanks for your kind response but i want you to know this is not working on mine side could you please have a look again?

    https://www.jbbess.com/


    • Edited by jbbesss Wednesday, May 18, 2022 6:56 PM
    Wednesday, May 18, 2022 6:54 PM
    |
  • Question
    Sign in to vote
    0
    Sign in to vote

    I had the same problem before. Assuming you are using Windows 11 you can try to install the older version for Office 2010 and upgrade from there.

    https://www.microsoft.com/en-us/download/details.aspx?id=29061 is the download for this version.

    Thursday, May 26, 2022 11:46 AM
    |
  • Question
    Sign in to vote
    0
    Sign in to vote
    Thanks for the solutions !
    Thursday, May 26, 2022 12:54 PM
    |
  • Question
    Sign in to vote
    0
    Sign in to vote
    PEPEK ANJENG PEPEK ANJENGPEPEK ANJENG PEPEK ANJENGPEPEK ANJENG PEPEK ANJENGPEPEK ANJENG PEPEK ANJENGPEPEK ANJENG PEPEK ANJENGPEPEK ANJENG PEPEK ANJENGPEPEK ANJENG PEPEK ANJENGPEPEK ANJENG PEPEK ANJENGPEPEK ANJENG PEPEK ANJENGPEPEK ANJENG PEPEK ANJENGPEPEK ANJENG PEPEK ANJENGPEPEK ANJENG PEPEK ANJENGPEPEK ANJENG PEPEK ANJENGPEPEK ANJENG PEPEK ANJENGPEPEK ANJENG PEPEK ANJENGPEPEK ANJENG PEPEK ANJENGPEPEK ANJENG PEPEK ANJENGPEPEK ANJENG PEPEK ANJENGPEPEK ANJENG PEPEK ANJENGv
    Saturday, May 28, 2022 9:09 AM
    |
  • Question
    Sign in to vote
    0
    Sign in to vote
    PEPEK ANJENG PEPEK ANJENGPEPEK ANJENG PEPEK ANJENGPEPEK ANJENG PEPEK ANJENGPEPEK ANJENG PEPEK ANJENGPEPEK ANJENG PEPEK ANJENGPEPEK ANJENG PEPEK ANJENGPEPEK ANJENG PEPEK ANJENGPEPEK ANJENG PEPEK ANJENGPEPEK ANJENG PEPEK ANJENGPEPEK ANJENG PEPEK ANJENGPEPEK ANJENG PEPEK ANJENGPEPEK ANJENG PEPEK ANJENGPEPEK ANJENG PEPEK ANJENGPEPEK ANJENG PEPEK ANJENGPEPEK ANJENG PEPEK ANJENGPEPEK ANJENG PEPEK ANJENGPEPEK ANJENG PEPEK ANJENGPEPEK ANJENG PEPEK ANJENGPEPEK ANJENG PEPEK ANJENGPEPEK ANJENG PEPEK ANJENGPEPEK ANJENG PEPEK ANJENGPEPEK ANJENG PEPEK ANJENGPEPEK ANJENG PEPEK ANJENGPEPEK ANJENG PEPEK ANJENGPEPEK ANJENG PEPEK ANJENGPEPEK ANJENG PEPEK ANJENGPEPEK ANJENG PEPEK ANJENGv
    Saturday, May 28, 2022 9:09 AM
    |
  • Question
    Sign in to vote
    0
    Sign in to vote
    PEPEK ANJENG PEPEK ANJENGPEPEK ANJENG PEPEK ANJENGPEPEK ANJENG PEPEK ANJENGPEPEK ANJENG PEPEK ANJENGPEPEK ANJENG PEPEK ANJENGPEPEK ANJENG PEPEK ANJENGPEPEK ANJENG PEPEK ANJENGPEPEK ANJENG PEPEK ANJENGPEPEK ANJENG PEPEK ANJENGPEPEK ANJENG PEPEK ANJENGPEPEK ANJENG PEPEK ANJENGPEPEK ANJENG PEPEK ANJENGPEPEK ANJENG PEPEK ANJENGPEPEK ANJENG PEPEK ANJENGPEPEK ANJENG PEPEK ANJENGPEPEK ANJENG PEPEK ANJENGPEPEK ANJENG PEPEK ANJENGPEPEK ANJENG PEPEK ANJENGPEPEK ANJENG PEPEK ANJENGPEPEK ANJENG PEPEK ANJENGPEPEK ANJENG PEPEK ANJENGPEPEK ANJENG PEPEK ANJENGPEPEK ANJENG PEPEK ANJENGPEPEK ANJENG PEPEK ANJENG
    Saturday, May 28, 2022 9:09 AM
    |
  • Question
    Sign in to vote
    0
    Sign in to vote

    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:

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

    Greetings,

    Peter

    Wednesday, July 6, 2022 8:57 AM
    |
  • Question
    Sign in to vote
    0
    Sign in to vote

    Data Mining Add Ins
    Installing and Activating the Data Mining Add-In

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

    Greetings,
    Peter

    Monday, August 8, 2022 6:43 AM
    |
  • Question
    Sign in to vote
    0
    Sign in to vote
    thanks, i found the answer here
    Sunday, January 8, 2023 9:22 PM
    |
  • Question
    Sign in to vote
    0
    Sign in to vote
    Thanks for the answer, it helped me
    Thursday, January 12, 2023 10:56 AM
    |
  • Question
    Sign in to vote
    0
    Sign in to vote

    Download Microsoft SQL Server Data Mining Add-ins for Microsoft Office. Insert the following entry in the Windows registry..Proceed with installation which now shouldn’t complain about missing Excel...Now you can use your SQL Server Data Mining Add-ins

    Friday, January 13, 2023 11:54 AM
    |