locked
Excel 2013 MDS Add-In RRS feed

  • Question

  • We are playing around with Excel 2013 to see what changes are coming, but can't find an MDS Add-In that will work.  The existing MDS SQL 2012 Add-In won't install on top of Office 2013.

    Thanks



    • Edited by Michael E. Burger Friday, November 2, 2012 4:15 PM removing old link in signature
    Friday, November 2, 2012 4:12 PM

Answers

  • Confirmed, this is fixed in SQL 2012 SP1 which was released yesterday: FIX: Master Data Services Add-in for Excel cannot be installed on a computer that has Microsoft Office 2013 installed http://support.microsoft.com/kb/2674319
    • Proposed as answer by wBob Thursday, November 8, 2012 6:47 PM
    • Marked as answer by Elvis Long Friday, November 9, 2012 8:04 AM
    Thursday, November 8, 2012 6:47 PM

All replies

  • I got the SQL 2012 SP1 CTP3 version to work with Excel 2013 - but I wouldn't recommend installing a CTP unless you have virtual machine or sandbox to play with.

    Prerequisite:
    Visual Studio 2010 Tools for Office Runtime
    http://www.microsoft.com/en-us/download/details.aspx?id=20479

    Microsoft® SQL Server® 2012 SP1 Community Technology Preview Feature Pack
    http://www.microsoft.com/en-us/download/details.aspx?id=34702

    Sunday, November 4, 2012 2:21 PM
  • Confirmed, this is fixed in SQL 2012 SP1 which was released yesterday: FIX: Master Data Services Add-in for Excel cannot be installed on a computer that has Microsoft Office 2013 installed http://support.microsoft.com/kb/2674319
    • Proposed as answer by wBob Thursday, November 8, 2012 6:47 PM
    • Marked as answer by Elvis Long Friday, November 9, 2012 8:04 AM
    Thursday, November 8, 2012 6:47 PM
  • So, I've downloaded SQL 2012 SP1 64-bit and applied it to my MDS instance.  I also used the MDS Add-In for Excel in my Office 2013 RTM 64-bit and it's not populating the "Show Explorer" option.   I have the Prerequisite for Visual Studio 2010 Tools for Office 64-bit as well.

    Publishing works fine with a new entity.  But I cannot select a model from "Show Explorer" because the pop-up does not appear.

    Is there a 64-bit issue?

    Friday, November 16, 2012 10:49 PM
  • Daniel,

    Apparently, it is not a 64-bit issue. I get the same behavior in Excel 2013 32-bit: Show Explorer button does not show explorer. I will continue to explore this issue, and let you know if I mange to get a solution.

    Dejan Sarka

    Tuesday, November 20, 2012 5:55 PM
  • I am also getting the error. Excel 2013 installed on a 2012 server, sql2012. when I run the fix. I get the same error.

    run MasterDataServicesExcelAddin_amd64.msi

    any idea why the fix wont work?

    regards

    Ian

    Tuesday, November 20, 2012 7:30 PM
  • Hi Ian,

    Have you install Visual Studio 2010 Tools for Office Runtime? Please try to install this component, we can get it from the following link:
    http://www.microsoft.com/en-us/download/details.aspx?id=20479

    Regards,


    Bin Long

    TechNet Community Support

    Wednesday, November 21, 2012 1:07 AM
  • that worked.thank you
    Wednesday, November 21, 2012 5:25 AM
  • Daniel,

    You might want to follow the progress of resolving this bug at http://connect.microsoft.com/SQLServer/feedback/details/771856/excel-2013-mds-add-in-show-explorer-does-not-work#tabs

    Dejan Sarka

    Wednesday, November 28, 2012 7:34 AM
  • Ian,

    Tried to download but it says "page not available"?

    Monday, December 3, 2012 10:18 PM
  • Did find a link here but can't test unfortunately.
    Monday, December 3, 2012 11:04 PM
  • The Visual Studio 2010 Tools for Office Runtime can now be found at a new location:  http://go.microsoft.com/fwlink/?LinkId=140384.  Forward links (such as from the documentation pages) have already been updated to reflect the new location, but unfortunately that link could not be re-used for the latest version of the runtime (released a few weeks ago, and featuring support for .NET 4.5 and Office 2013).


    Michael Zlatkovsky | Program Manager, Visual Studio Tools for Office & Apps for Office


    Monday, December 3, 2012 11:43 PM
  • Ian,

    Tried to download but it says "page not available"?

    Daniel, see my response above.  The link you want is http://go.microsoft.com/fwlink/?LinkId=140384.  We're still working on updating any stray links, including the one you'd found -- thanks for bringing it up to my attention.

    Michael Zlatkovsky | Program Manager, Visual Studio Tools for Office & Apps for Office


    Monday, December 3, 2012 11:46 PM
  • Michael,

    I've located the file and downloaded.  Installation went through successfully.   However, I'm still getting the same response :(

    I'm running on Windows 8 Pro if that was not clear earlier.

    I have a concern that there's some .NET compatibility setting I need to resolve with IIS.  What should the application pool framework version, managed pipeline and Identify settings be?

    Tuesday, December 4, 2012 3:50 AM
  • Hi Daniel,

    It's a great question, but unfortunately, that's not something I have any context on.  I just noticed the old VSTO Runtime link when I did an unrelated Bing search, so I wanted to make sure this wasn't the issue.  I do hope you find the answer from someone else on the thread, though:  someone with specific knowledge about SQL Server and IIS!

    - Michael


    Michael Zlatkovsky | Program Manager, Visual Studio Tools for Office & Apps for Office

    Wednesday, December 5, 2012 8:06 PM
  • Michael,

    Would you confirm that the following link is correct for the SQL Server 2012 SP1 Master Data Add-In for Excel 2013?

    http://www.microsoft.com/en-us/download/details.aspx?id=35581

    I'm downloading the 64-bit version.

    Thursday, December 6, 2012 1:27 AM
  • Daniel, I unfortunately have no context on SQL Server:  I only wanted to chime in on the latest link to the VSTO runtime, since I noticed the original link was incorrect.  Beyond that, I unfortunately don't know about the MasterDataServicesExcelAddin (though the link you sent does look good in terms of being published recently, only a month ago).

    Best of luck,

    - Michael


    Michael Zlatkovsky | Program Manager, Visual Studio Tools for Office & Apps for Office


    Thursday, December 6, 2012 1:32 AM
  • I'm facing the issue that Explorer task pane is not showing pane. I'd to check if anyone has other tips (repairing the installation did not solve it for me).

    Half Scheidl

    Tuesday, January 15, 2013 5:05 PM
  • Installed Visual Studio 2010 Tools for Office Runtime from http://www.microsoft.com/en-au/download/details.aspx?id=35594 and all works fine now.


    Sreedhar

    Thursday, February 7, 2013 3:14 AM
  • Michael,

    Had some "down time" and focused on determining the root cause of the issue.  Good news is that I think I got it working :)   Bad news is that it's a manual process every time I open up Excel :(

    1.   Launch Excel

    2.   Open Blank workbook

    3.   Go to File->Options

    4.   Select Add-Ins under "Excel Options" dialog

    5.   Under "Manage:" select COM Add-In" click on the "Go" button

    6.   In the "COM Add-Ins" dialog, uncheck "Master Data Services Add-in for Excel" and select the "OK" button

    7.   You will return to the blank workbook and the "Master Data" tab should be gone (if not repeat steps 3-5)

    8.   Repeat Step 3-5 to return to the "COM Add-In" dialog

    9.   In the "COM Add-Ins" dialog, check "Master Data Services Add-in for Excel" and select the "OK" button

    10. You will return to the blank workbook and the "Master Data" tab should be there (if not repeat steps 8-9)

    11. Select the "Master Data" tab and click on Connect.   Master Data Explorer appears!

    So - how can I get around having to manually reset this in Excel every time I open it???   The only option I'm faced with right now is to rebuild from scratch (OS, Office) since a repair or re-install of Office does not appear to address the problem.

     

    Tuesday, February 12, 2013 7:00 PM
  • A new version of the MDS Excel Addin is available from

    http://www.microsoft.com/en-us/download/details.aspx?id=35581

    Please see KB article

    http://support.microsoft.com/kb/2840614/en-us

    Friday, July 12, 2013 5:53 PM
  • I realize this is an old thread, but I continue to struggle with this issue and have followed every article linked on this page and many others and have installed every prerequisite and then some.  I can't help but think that the posted MDS Excel Add-In has been inadvertently regressed to a version that no longer supports Excel 2013, or that there is some undocumented step or step-sequence that is required above what has been documented.

    My system: Windows 8.1 Update (x64), Office Professional Plus 2013 (x64), SQL Server 2012 SP1+CU10 (11.00.3431) Developer Edition (x64). Also tried to no avail on 11.00.3000 prior to applying the CU.

    It works on my PC at work, but not on my home PC (above) and I can't fathom what is different.


    Jason

    Friday, June 6, 2014 1:49 AM
  • Jason, can you describe in what way does it not work? (doesn't load, doesn't show explorer, won't connect to the server, etc)? Do you have other office addins installed and working on that machine?
    Friday, June 6, 2014 4:04 AM
  • By the way, If this is something time sensitive or urgent, Jason you can open a paid support ticket, or use an MSDN account to get assisted support (some free tickets are included I believe).

    The starting URL is here: http://support.microsoft.com/select/default.aspx?target=assistance


    Didn't get enough help here? Submit a case with the Microsoft Customer Support team for deeper investigation - http://support.microsoft.com/select/default.aspx?target=assistance

    Friday, June 6, 2014 10:29 PM
  • Thank you for the response. The exact error message I'm getting is "These prerequisites are not installed: 64-bit version of Microsoft Excel 2010".

    It's true. I don't have 2010 installed. I have Office Professional Plus 2013 instead, and am trying to install the MDS Add in from this link with no luck.  I've also installed the Visual Studio 2010 Tools for Office Runtime from the link in this thread. But, nothing seems to make a difference.

    I'm at a loss. I started from a clean install of everything.


    Jason

    Tuesday, June 10, 2014 3:08 AM
  • I think that the error message may be deceiving. The error you are hitting probably has to do with 32 vs 64 bit platform. You can verify the architecture of your Excel:

    http://office.microsoft.com/en-us/support/am-i-running-32-bit-or-64-bit-office-HA010361023.aspx

    The tricky thing I recall is that the VS Tools for Office Runtime that you want needs to match your machine architecture, regardless of the Office architecture. So I just verified on my 64-bit OS, that I have 64-bit VSTO and 32-bit Office.

    Then you need the Excel add-in that matches your Office architecture. On my machine, I have 32-bit MDS Excel Add-in. This link will allow you to choose the architecture after you click Download:

    http://www.microsoft.com/en-us/download/details.aspx?id=35581

    HTH,

    Lynn


    Tuesday, June 10, 2014 9:24 PM
  • You were right. That was it. Everything else on my system is 64-bit, but seems that I have the 32-bit version of Office. I hadn't even thought to check. Installed the 32-bit version of the Add-In and it worked without issue.  Thank you!

    Jason

    Wednesday, June 11, 2014 1:32 AM