Office Settings & Configuration

Fix the Missing SQL Server MDS Add-in in Excel

Amos GikundaAmos Gikunda Nov 13, 2026 868 views

Question details

The user needs the SQL Server 2014 Master Data Services add-in to appear and work in Excel.

Fix the Missing SQL Server MDS Add-in 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.
Before you start

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.

Solution 1Recommended

Update Office and check for the Master Data tab

Use this first when the MDS add-in installs but does not appear in Excel.

1
Open Office update settings

In Excel, select File > Account, then look for Update Options under Product Information.

2
Install available updates

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.

3
Restart Excel

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.

Update Office and check for the Master Data tab
Reported resolution: In the reported case, updating Office to version 2002 restored the Master Data tab. Use the latest available update supported by your Office installation.
Free Microsoft Office alternative

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.

Open and edit Microsoft Excel XLSX and XLS filesUse a familiar spreadsheet interface for everyday workbook tasksMove common Office files into a lightweight office suiteWork with spreadsheet data without requiring the MDS add-in for ordinary edits
microsoft office alternative - wps office

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.