Showing posts with label Master Data Services. Show all posts
Showing posts with label Master Data Services. Show all posts

Monday, January 26, 2015

Installing Master Data Services Add-in for MS-Excel version 2013

On a PC with an Office 2013 installation, the SQL Server 2012 MDS Add-in for MS-Excel will not install, the installer displays an error message that says Excel 2007 or 2010 is needed. The solution is simple, just download the SP1 version of the Add-in, you can find it here Microsoft® SQL Server® 2012 Service Pack 1 (SP1) Master Data Services Add-in For Microsoft® Excel®

The installation file to download for SP1 has exactly the same name as the version for Excel 2007/2010.

image

After download, run the MSI installation and when the installer has finished, you can see the new ‘Master Data’ item in the Excel menu

image

Hope this helps.