To check the version of the MDS Add-in for Excel
During the SQL Server 2012 prerelease time frame, the version of the Master Data Services Addin for Excel should closely match the version of the MDS server installation. For example, you should not use the CTP3 build of the MDS Add-in for Excel to connect
to a RC0 MDS Server.
2. Locate the two dll files named Microsoft.MasterDataServices.ExcelAddIn.dll and file
The file version may vary between the two in normal circumstances, so notice the higher version of the two files to indicate the build number.
3. Right click on this file, and view the
4. On the properties dialogue, click the Details tab.
5. Note the File version and the Product version fields.
For example 11.0.2100.60 is the version number for SQL Server 2012 RTM with no patches installed.
And 11.0.3368.0 indicates SQL Server 2012 with Service Pack 1, etc.
Note: Installing a SQL Server Cumulative Update Hotfix or Service Pack does not patch the Master Data Services Excel Add-in, so updates will have to be installed separately as needed on client computers.
As of September, 2011, this is because the MDS Add-in for Excel works with data in a Denali installation of MDS only. In the future, this error message may also apply to versions of the Add-in. For example, after Denali is released, if the web application
is still running CTP3, it must be upgraded before you can work in the Excel Add-in.
This error may also occur if the MDS Server Address provided in the connection string is not accurate. The address should be something similar to
http://computer/site. If you enter
http://computer/site/default.aspx or a similar string, this error may be displayed.
Common Error: A Formula or Sheet Contains the Name 'Leaf<GUID>'
You may get the error message:
This issue occurs when you copy and paste MDS-managed data between workbooks. It does not occur when you copy and paste between worksheets in the same workbook. The workaround for this issue is to paste values only.
Tip: When you want to share data with other users, you should publish it to the MDS repository and then share a shortcut query file with the other user. You should not copy and paste MDS-managed data between worksheets.
Enabling Diagnostic Logging for advanced troubleshooting
You can log the client side activities from the MDS Add-in for Excel and also log the server side activity from the MDS web application itself.
Typically both sides of the conversation are necessary to troubleshoot issues with the MDS Add-in for Excel.
A> Follow this KB article to edit the web application .config file to enable the server side logging for your MDS web application.
B> Also enable the logging in the Master Data tab in Excel.
To Enable Logging In SQL Server 2012 Release Candidate 0 (Nov 2011) and later prereleases of the MDS Add-in for Excel, to enable logging complete the following steps:
1. Open Excel, and click on the Master Data ribbon tab.
2. Click the Settings button
3. On the Settings tab check the box "Turn on detailed logging"
4. Reproduce the failure or error condition you are troubleshooting.
5. Visit the output folder to find the log output using Windows Explorer or My Computer to browse the C drive.
To Enable Logging for SQL Server 2012 "Denali" Community Technology Preview (CTP3) and prior releases, to get more detailed logging, complete the following steps:
1. Click Start.
2. Right-click Computer and choose Properties.
3. Click Advanced system settings.
4. Click Environment Variables.
5. In the User variables section, click New.
6. In the Variable name box, type VSTO_SUPPRESSDISPLAYALERTS.
7. In the Variable value box, type 0.
8. Click OK.
What about if the MDS Excel Add-in cannot be shown in the tab, and even after trying with active from the option? We have tried with your steps, and failed sometimes. We also try to uninstall the Add-in and Excel, and it does not help either. At last, we have to change another clean machine. I wonder is there any other method to resolve this problem? Thanks!
Hello Suzanne en Carsten,
I have trouble with the add in. I have installed the 2013 version (service pack1). After installation it is loaded in Excel and visual in the ribbon. After restart of excel the add in appears not to be started. Of course I can re-activate it under the comm.add ins, but I have to activate it each time I start excel. Is this problem known and if so is a fix available?
In my case I had to install the add-in from command line as administrator. Here is a link with more info about my issue www.katieandemil.com/mds-excel-2013-and-2010-add-in-installation
We are having the same issue. We have to reactivate the MDS add-in every time somebody opens Excel. This is time-consuming and simply a pain in the butt.
Has anybody found a fix for this yet? Come on Microsoft!? Get your act together!
thanks for sharing.
Hi TonyCapo, your best bet is to open a support ticket. The issue you describe where the Excel addin gets disabled is not prevalent with majority of our customers, so there may be something unique going on in your environment. Running the sysinternals tool called Process Monitor may show where the registry keys get edited to help track down the cause. Sorry for your trouble, but please do get in touch with support for further investigation. support.microsoft.com/.../default.aspx
Best regards, Jason