FIX: Can’t install Master Data Services Add-in for Excel on a computer that has Microsoft Office 2013 installed

Article translations Article translations
Article ID: 2774422
Expand all | Collapse all

On This Page

Symptoms

When you try to install the Microsoft SQL Server 2012 Master Data Services Add-in for Microsoft Excel on a computer that is running Microsoft Office 2013, the installation process is unsuccessful. Additionally, you receive the following error message:
These prerequisites are not installed:
64-bit version of Microsoft Excel 2010
All prerequisites can be installed from:
http://go.microsoft.com/fwlink/?linkId=219530

Notes
  • This issue occurs even if you install Microsoft Excel 2010 alongside Office 2013 on the computer.
  • You can install the Master Data Services Add-in for Excel after you uninstall Office 2013.
  • This issue does not occur if you install either the 2007 Microsoft Office system or Microsoft Office 2010 instead of Office 2013.

Resolution

Service pack information for SQL Server 2012

To use the Master Data Services Add-in for Excel, install the SQL Server 2012 Service Pack 1 Feature Pack. The SQL Server 2012 Service Pack 1 Feature Pack is available for download from the Microsoft Download Center:
Microsoft SQL Server 2012 Service Pack 1 Feature Pack

Note
The Service Pack 1 Feature Pack for the Master Data Services Add-in for Excel (or a later version of the feature pack) is required for the add-in to work with Office 2013.

Note You can also download the Microsoft SQL Server 2012 Master Data Services Add-in For Microsoft Excel from the Microsoft Download Center:

Microsoft SQL Server 2012 Master Data Services Add-in For Microsoft Excel

Choose the download that matches the 32-bit or 64-bit nature of the existing Excel 2013 installation.
  • For 64-bit Excel, download MasterDataServicesExcelAddin_amd64.msi.
  • For 32-bit Excel, download MasterDataServicesExcelAddin_x86.msi.
To determine which version of Excel is installed, start Microsoft Excel, and then create a new workbook. Click File, click the Account tab, and then click About Excel to see the version information.

Note To obtain the latest service pack, click the following article number to go to the article in the Microsoft Knowledge Base:
2755533 How to obtain the latest service pack for SQL Server 2012

Status

Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.

More information

The SQL Server 2012 Service Pack 1 Master Data Services Add-in for Excel is compatible with the 2007 Office system, Office 2010, and Office 2013. It is also compatible with the SQL Server 2012 and SQL Server 2012 Service Pack 1 versions of a Master Data Services server installation.

References

For more information about the Master Data Services Add-in for Excel, go to the following MSDN website:
Master Data Services Add-in for Microsoft Excel

Properties

Article ID: 2774422 - Last Review: January 9, 2013 - Revision: 6.0
Keywords: 
kbtshoot kbfix kbsurveynew kbexpertiseadvanced atdownload KB2774422

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com