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:

Microsoft SQL Server 2012 Service Pack 1 (SP1) 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.

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

Need more help?

Expand your skills
Explore Training
Get new features first
Join Microsoft Insiders

Was this information helpful?

What affected your experience?

Thank you for your feedback!

×