Sunday, February 17, 2013 2:57 PM
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?
Monday, February 18, 2013 5:51 AM
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.
Monday, February 18, 2013 10:56 AM
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
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.
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
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
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
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 AMModerator
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
TechNet Community Support