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 dll file named Microsoft.MasterDataServices.ExcelAddIn.dll
3. Right click on this file, and view the Properties.
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.
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.