Fix the Missing SQL Server MDS Add-in in Excel
Question details
The user needs the SQL Server 2014 Master Data Services add-in to appear and work in Excel.

- Product
- Microsoft Excel and SQL Server 2014 Master Data Services Add-in for Excel
- Device & OS
- not provided
- Scenario
- The add-in installs successfully, and the user wants to access Master Data Services from Excel.
- Observed behavior
- The Master Data tab does not appear, and the add-in is missing from Excel's COM Add-ins list.
In Excel, open File > Account > About Excel and note the Office version and whether Excel is 32-bit or 64-bit. Check Microsoft's SQL Server 2014 MDS add-in requirements and confirm that your Excel installation is supported.
Update Office and check for the Master Data tab
Use this first when the MDS add-in installs but does not appear in Excel.
In Excel, select File > Account, then look for Update Options under Product Information.
Select Update Options > Update Now and let Office install the available updates. If Update Options is unavailable, contact your Office administrator or check the update method for your installation.
Close and reopen Excel, then look for the Master Data tab on the ribbon. If it is still missing, go to File > Options > Add-ins, select COM Add-ins in the Manage box, and click Go to check the list.

Verify the MDS add-in installer and compatibility
Check the installer and requirements if updating Office does not make the add-in available.
Run an Office Online Repair
Repair Office if the add-in and system requirements are correct but the Master Data tab is still missing.
Work with Excel files in WPS Office
WPS Office is a free, lightweight alternative with a familiar interface for working with Office files. It supports migration of common spreadsheet files, but it does not fix or replace the Microsoft SQL Server MDS add-in.

Frequently Asked Questions
Where can I check whether the MDS add-in is enabled?
In Excel, go to File > Options > Add-ins. Select COM Add-ins in the Manage box and click Go. If the MDS add-in is listed, select its checkbox.
What if the add-in is not in the COM Add-ins list?
Check that the installer came from Microsoft and matches your Excel bitness, then verify the SQL Server 2014 MDS add-in requirements. Update Office and restart Excel before checking the list again.
How do I find out whether Excel is 32-bit or 64-bit?
Open Excel and select File > Account > About Excel. The About window shows the installed Office version and bitness.
Does WPS Office run the SQL Server MDS add-in?
WPS Office is an alternative for working with common Excel files, but it does not fix or replace the Microsoft MDS add-in. Use a supported Microsoft Excel configuration for MDS.




