Fixing the Microsoft MDS Excel Add-In so it Stays Enabled

If you use Microsoft’s Master Data Services Excel add-in, then you may have experienced this problem.  Every time you start Excel the Master Data button has disappeared from the ribbon, and you have to enable the MDS add-in from the option menu each time.  This was a time-consuming headache during a project I worked on until I finally figured out this solution:

  1. Press the Start button (Windows button)
  2. In the search bar type “REGEDIT”
    1. 1
  3. Open regedit.exe
  4. A pop-up will ask permission for the Registry Editor to make changes to the computer, select Yes.
  5. In the Registry Editor expand HKEY_CURRENT_USER
    1. 2
  6. In the HKEY_CURRENT_USER folder, expand in the following order: Software -> Microsoft -> Office -> Excel -> Addins
  7. Select Microsoft.MasterDataServices.ExcelAddIn
    1. 3
  8. Double-click on LoadBehavior in the right panel
  9. In the Edit Value popup, change the value to 3
    1. 4
  10. Press OK, it should now look something like this:
    1. 5
  11. Exit the Registry Editor

The excel add-in should now be active anytime you open Excel. If multiple errors occur while using the add-in, the Load Behavior may change back to 0. If that occurs simply follow these steps so the add-in will be active when Excel starts up.

I hope this helps you get past this simple error before it gives you as much headache as it did me.

Cheers!

 

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s