MDS 2016 Excel Plug In Not Working RRS feed

  • Question

  • Hi All

    Good Day!!

    I am working on MDS 2016 as a developer and require excel plug-in for performing bulk data inserts, updates and deletes.

    Though, it is a fairly simple installation process outlined by MS and same steps works on my colleagues' machine, but on my machine it does not. For clarity of problem, I will outline below exact steps followed by me for installation:

    Excel Version:  MS Excel 2016 32 Bit

    SQL Server Version : 2016

    Runtime Installed  : MS Visual Studio Tools for Office Runtime 2010 

    Excel Add In Installed : MasterDataServicesExcelAddinSS16

    Step 1 - Install the VS tools mentioned above on local machine (where excel is installed)

    Step 2 - Install Excel Plug In mentioned above

    Post this, after opening excel I am able to see the Master Data Tab available will multiple options.

    But while I am trying to establish a connection to SQL server, nothing happens. I created a Dev connection as per below image:

    But when I click on test or connect, nothing error message, no loading screen. I tried many possible solutions available over the internet but did not happen. Can you please help me with the solution to this?

    Let me know if further info is required for debugging the issue.

    Many Thanks


    Wednesday, October 10, 2018 8:11 AM


All replies