Resolve the GetCustomUI for RibbonID Microsoft.Excel.Workbook Error

Custom UI Runtime Error in Visual Studio Tools for Office Design-Time Adaptor for Excel

This error drove me crazy because I could only find pieces of the answer, but never the whole answer.  Here’s the whole answer that resolved the problem for me.

The Error: The Call to GetCustomUI() for RibbonID “Microsoft.Excel.Workbook” failed.


It typically comes up after an installation of Microsoft Office and Visual Studio.  Somehow the combination of these two causes the problem and Microsoft hasn’t figured out why, or how.  There is a workaround.

Step 1: Open Excel in Administrator mode

There are two ways to do this.

A) Right click on the Excel shortcut and click on Properties in the context menu. In the properties dialogue click the Advanced button. In the Advanced Properties dialogue check off “Run as Administrator” and click OK on all the open dialogues.

B) Click the Start Button, or the Windows button.  Type Excel in the search box.  Press SHIFT + CTRL + Enter

Open a blank workbook

Step 2: Activate the Developer Tab in the Ribbon if isn’t availableCustomize_the_Ribbon

In the workbook file menu select “Options” and in the Options menu select “Customize Ribbon”.

In the right hand list of the Ribbon Customizer you should see a list of tabs.  Make sure the “Developer” tab is selected.

Click OK to close the Customizer

Step 3: Turn off the “Visual Studio Tools for Office Design-Time Adaptor for Excel”

In the Ribbon select the Developer tab.com_Addin

In the Developer tab select the “COM Add-Ins”

In the COM Add-Ins dialogue look for the “Visual Studio Tools of Office Design-Time Adaptor for Excel” add in.  You’ll likely see one for every version of Visual Studio that you’ve installed on this particular machine. Uncheck all of them and click OK out of the dialogue


That should immediately resolve the problem.

Once you open Excel in non-Administrator mode you might encounter the problem again.  If that’s the case follow the above steps without opening Excel as an Administrator.

27 comments for “Resolve the GetCustomUI for RibbonID Microsoft.Excel.Workbook Error

  1. cynett
    January 13, 2015 at 10:20 am

    I have the same problem in Excel 2013 and this resolved it. THNX.

  2. Rafael Barros
    February 27, 2015 at 8:15 pm

    This works like a charm!
    You rock! Thanks.

  3. silverfox1948
    March 12, 2015 at 10:54 pm

    It worked. Thanks!

  4. Pete
    July 2, 2015 at 9:16 am

    This annoyed me greatly! Thank you for saving me lots of annoyances!! 🙂

  5. myT
    October 8, 2015 at 4:24 am

    thx, cristal clear info

  6. Rajen
    November 1, 2015 at 10:17 pm

    Worked like charm… Thanks.

  7. January 25, 2016 at 4:16 pm

    Yes, it worked. Thanks!

  8. santhi chandrasekaran
    May 27, 2016 at 1:38 am

    Thanks. It worked.

  9. th
    June 7, 2016 at 8:40 pm

    Perfect! Thank you!

    I my case it was a document creator for a Samsung scanner that was causing the problem.

  10. Angeljo
    August 23, 2016 at 5:07 am

    Thanks. it’s working

  11. Ben
    September 23, 2016 at 11:06 am

    Finally a resolution that actually works. Thanks so much for posting this!

  12. Leo
    December 5, 2016 at 1:50 pm

    Yeah, but I need that on as I’m doing VSTO development. This doesn’t really solve the problem.

  13. December 31, 2017 at 7:53 pm

    solucionado gracias

  14. Frank
    January 30, 2018 at 8:24 am

    Great help. Thanks a lot.

  15. Tao
    May 8, 2018 at 10:14 am

    It works for me. Thank you.

  16. Niels Kristensen
    June 3, 2018 at 3:33 am

    thank you very much – worked for me

  17. madmike
    July 3, 2018 at 6:43 am

    I am not sure why I want to disable something in stead of fixing it. Do you know the root cause and how to do fix that? (is Microsoft working on this?)

    • July 5, 2018 at 2:23 pm

      I’m not aware of any fix to this problem from Microsoft. This bug showed up in older versions of Excel, so maybe Office 365 has corrected this problem?

  18. July 5, 2018 at 5:17 pm

    Worked fine for me today. Thanks a lot for saving me much time of annoying search.

  19. Lori Coleman
    August 12, 2018 at 2:56 pm

    Thanks So MUCH!!! I’ve been fighting this for several weeks and finally located your site. Thanks for sharing with the community and being thorough about how to fix it!

    • August 12, 2018 at 8:55 pm

      You’re welcome! I’m glad it helped.

  20. September 11, 2018 at 9:08 pm


  21. ashwin
    February 5, 2019 at 1:28 pm

    This worked! Thank you.

  22. Minny
    April 9, 2019 at 8:44 pm

    this is cool. no need for “run as admin” for Excel 2016′ thanks

  23. Mat
    August 2, 2019 at 5:22 pm

    This worked like a charm thank you for the help

  24. John Zabroski
    October 31, 2019 at 9:59 am


Leave a Reply

Your email address will not be published. Required fields are marked *