Installing the MDS add-in for Excel 2016

For some reason I attract all kinds of misery when working with Master Data Services. Today I was trying to install the add-in for SQL Server 2012 on a machine that has Office 2016 64-bit installed. I clicked on the link in the MDS webpage which send me to the download page of the MDS 2012 SP1 add-in. However, I was greeted with the following error message when running the installer:

These prerequisites are not installed: 64-bit version of Microsoft Excel 2010

I had all the prerequisites installed (.NET framework 4.6.2 and the Visual Studio 2010 Tools for Office Runtime) and the correct bitness. A quick search led me to this KB article:

FIX: Can’t install Master Data Services Add-in for Excel on a computer that has Microsoft Office 2013 installed

The article says you can get rid of the error message by using the 2012SP1 installer. Which I was using. Dead end. I also found this post at Katie&Emil: MDS Excel 2013 and 2010 Add-in Installation. Emil had the same issue and succeeded in installing the add-in by running the installer as admin through the command line. However, I still got the same error. That add-in must really hate Office 2016.

So I installed the SQL Server 2016 add-in which did install successfully, but apparently isn’t able to connect to SQL Server 2012. No backwards compatibility. I turned to Twitter and someone suggested me to install the 2014 add-in. Luckily, this one does install and fortunately has backwards compatibility with SQL Server 2012.

To wrap everything up:

 

Koen Verbeeck

Koen Verbeeck is a Microsoft Business Intelligence consultant at AE, helping clients to get insight in their data. Koen has a comprehensive knowledge of the SQL Server BI stack, with a particular love for Integration Services. He’s also a speaker at various conferences.

Leave a Reply

Your email address will not be published. Required fields are marked *