Fix: The Call to GetCustomUI for RibbonID Microsoft.Excel.Workbook failed

Problem

I have received the error message The Call to GetCustomUI() for RibbonID “Microsoft.Excel.Workbook” failed with the title Custom UI Runtime Error in Visual Studio Tools for Office Design-Time Adaptor for Excel when opening the Excel application. In my environment the below error comes when I open the Excel application that comes with Microsoft Office Professional Plus 2016.

Error - The Call to GetCustomUI for RibbonID Microsoft.Excel.Workbook failed

Solution

After analyzing some time found that this error is coming due to the COM Add-In Visual Studio Tools for Office Design-Time Adaptor for Excel. So to fix/remove this error, we need to enable Developer tab and turn off the problematic COM Add-In.

Follow the below steps to disable COM Add-In:

  • In Excel, click File menu and select Options.
Step 1 - Fix The Call to GetCustomUI for RibbonID Microsoft.Excel.Workbook failed
  • In the Options menu select Customize Ribbon. In the right-hand side, you can see the Developer tab under Main Tabs, make sure that this tab is selected and click OK to save the changes.
Step 2 - Fix The Call to GetCustomUI for RibbonID Microsoft.Excel.Workbook failed
  • Now you can see the Developer tab menu. Under the Developer tab ribbon, click on COM Add-Ins
Step 3 - Fix The Call to GetCustomUI for RibbonID Microsoft.Excel.Workbook failed
  • In the COM Add-Ins window, look for the add in Visual Studio Tools of Office Design-Time Adaptor for Excel and Uncheck it (If you find multiple entries, uncheck all the entries).
Step 4 - Fix The Call to GetCustomUI for RibbonID Microsoft.Excel.Workbook failed
  • This will fix the issue, now you can close the Excel app and open it again to check the problem is solved or not.
Advertisement

5 thoughts on “Fix: The Call to GetCustomUI for RibbonID Microsoft.Excel.Workbook failed”

  1. When I open a worksheet the problem has disappeared. When I close and reopen Excel the problem recurs. How can I remove the problem entirely? the add-ins are set to load at startup of Excel.

    Reply

Leave a Comment