Master Data Services Add-In for Microsoft Excel - Error connecting to web url

So you have successfuly installed the Master Data Services Add-In for Microsoft Excel and now you want to connect to your Master Data Services on your Server.

Select the "Master Data" tab in Excel

Click Connect


Create a new connection

In the Add New Connection put in your Web URL from the Server.

If you get the following error:

The connection failed because the URL is not valid or the are abortions free Mast Data Manager web application version is not supported.

This is usually because you just need to remove the default.aspx from the Web URL abortion pill safety e.g.

http://MSDServer:8081/Default.aspx (as seen in IE)

Now becomes

http://MSDServer:8081 (in MDS Excel Add-In)

Simple when you realise this!

Comments are closed