DetailPage-MSS-KB

Microsoft small business knowledge base

Article ID: 2774422 - Last Review: February 12, 2015 - Revision: 7.0

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

Note The SQL Server 2012 Service Pack 1 version 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.

You can download the Microsoft SQL Server 2012 Service Pack 1 (SP1) Master Data Services Add-in For Microsoft Excel from the Microsoft Download Center:

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.

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 (http://msdn.microsoft.com/en-us/library/hh231024.aspx)
Keywords: 
kbtshoot kbfix kbsurveynew kbexpertiseadvanced atdownload KB2774422
Share
Additional support options
Ask The Microsoft Small Business Support Community
Contact Microsoft Small Business Support
Find Microsoft Small Business Support Certified Partner
Find a Microsoft Store For In-Person Small Business Support