Sign in
 
Home20122008 R2200820052000LibraryForums
SQL Server >
> 
> 
Can't install master data services add-in for excel 2010

Answered Can't install master data services add-in for excel 2010

  • Sunday, February 17, 2013 2:57 PM
     
     
    Sign In to Vote
    0

    Attempting to install the master data services add-in for excel using 'MasterDataServicesExcelAddin.msi' and although I have all pre-requisites including office 2010 for home and business (including excel) the installer gives me the error dialogue with the message that I don't have excel 2007 or 2010.

    I currently have the enterprise evaluation copy of sql server 2012 SP1. I'll have a licenced developer edition soon - will that solve my problem?

     

All Replies

  • Monday, February 18, 2013 5:51 AM
     
     
    Sign In to Vote
    0

    Hello,

    It might have happened that, excel 64 bit is installed and excel add-in which you are trying to intall could be of 32 bit or Vice-Versa. Check the error message properly (The error message would have the complete information) and install the right msi depending on your excel installation.

    Thanks.

     
  • Monday, February 18, 2013 10:56 AM
     
     
    Sign In to Vote
    0

    Thanks for the reply Nagesh.

    I should have provided more information...

    I do indeed have the 32 bit version of excel installed on windows 7.

    I also have Microsoft Visual Studio 2010 Tools for Office Runtime (x64) - perhaps there's a 32 bit version I should use?

    .net 3.5 and 4.5 installed.

    I have also configured master data services as far as setting up the database and web application and accessing the web application

     
  • Monday, February 18, 2013 11:13 AM
     
     
    Sign In to Vote
    0

    Hi,

    Its not the visual studio 2010 tools i am talking about. Its the 32 bit / 64 bit "MasterDataServicesExcelAddin.msi". On the msi download link, there are two msi's with the same name.

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

    Since your excel is 32 bit version, download and install the one highlighted below: -

    If its still an issue, provide the error screen shot.

     
  • Monday, February 18, 2013 11:39 AM
     
     
    Sign In to Vote
    0

    Sorry again - I should have been clearer - it's the x86 32 bit installer that I'm using but still getting the message (albeit incorrect) that I don't have the 32 bit version of excel 2007 or 2010

    Apologies but can't insert images until my account is verified apparenty

    • Edited by CraigFerrier Monday, February 18, 2013 11:46 AM
    •  
     
  • Monday, February 18, 2013 12:13 PM
     
     
    Sign In to Vote
    0

    Sorry craig. The only last suggestion i have is to double check if 32 bit Excel is installed or not.

    If your excel is 2007, then it is for sure 32bit. If the excel is 2010, then you can check if it is 32 bit / 64 bit by: -

    File (Menu Item) --> Help.

     
  • Monday, February 18, 2013 2:16 PM
     
     
    Sign In to Vote
    0

    Thanks a lot for the effort anyway Nagesh - yup - my version of excel is as above.

    I'm now having the same problem when I attempt to instal the power pivot add-in :-(

     
  • Thursday, February 21, 2013 7:28 AM
    Moderator
     
     Answered
    Sign In to Vote
    0

    Hi CraigFerrier,

    It is hard to reproduce this issue on my test environment. In this case, you can try to install installed Service Pack 1 for SQL Server 2012 to see if this issue still persists.

    If so, please reinstall Office 2010 32bit version. In addition, I googled the following KB article for your reference:
    Can’t install Master Data Services Add-in for Excel on a computer that has Microsoft Office 2013 installed: http://support.microsoft.com/kb/2774422

    Regards,

    Elvis Long
    TechNet Community Support