Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

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


View products that this article applies to.

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.

↑ Back to the top


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.

↑ Back to the top


Status

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

↑ Back to the top


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.

↑ Back to the top


References

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

↑ Back to the top


Keywords: kbtshoot, kbfix, kbsurveynew, kbexpertiseadvanced, atdownload, kb

↑ Back to the top

Article Info
Article ID : 2774422
Revision : 3
Created on : 9/14/2018
Published on : 9/14/2018
Exists online : False
Views : 190