Excel Add-In not displayed in ribbon due to Group Policy setting

Excel Add-In not displayed in ribbon due to Group Policy setting

Problem: The Excel Solver Add-in is enabled and appears to load during startup, but is not displayed/visible in the ribbon.

Solution: Update the Group Policy setting titled “Disable UI extending from documents and templates” to uncheck/disable “Disallow in Excel”.


Today I encountered another interesting customer environment setting that caused unusual behavior in our software, this time with Excel. I received a question from a data analyst who was trying to use the Solver Add-In in Excel 2013, but no matter what he tried, the Solver button would not get displayed in the Data ribbon. We enabled the Solver Add-in and saw the message during startup that the add-in was being loaded, but it was not visible in the toolbar ribbon. The following screenshot shows it being loaded during startup.

Excel Solver Add-In

After scouring several online threads and blog entries, we finally isolated the issue down to a specific GPO Group Policy setting, thanks to outstanding support from fellow Microsoft colleagues Jacob Heaton, Justin Abel, and Karl Camacho.

From gpresult output:

Excel Add-In Not Visible in Ribbon


To update the GPO setting that is preventing the button from being added:

  1. Launch gpedit.msc
  2. Navigate to User Configuration -> Administrative Templates -> Microsoft Office 2013 -> Global Options -> Customize -> Disable UI Extending from documents and templates.
  3. Uncheck “Disallow in Excel”
  4. Close gpedit
  5. Run “gpupdate /force” to update the change on the local machine
  6. Launch Excel and verify that the Solver add-in is displayed in the Data -> Analysis ribbon

Excel Add-In Not Visible in Ribbon

Sam Lester (MSFT)

Comments (5)

  1. Debu Bagchi says:

    How do you figure out if the Excel Solver Add-in is loading during startup? It is enabled but it still does not show up under the Data ribbon. I have modified the GPO as suggested here but it still does not work. Please help.

    1. Hi Debu, I just updated the article with a screenshot that shows the add-in loading during startup. Are you seeing solver.xlam listed during startup?


  2. George Potwin says:

    What happens when you require trusted publishers but the publisher certs expired.

  3. Elise Than says:

    I have the same problem. It was working just fine until my Excel 365 updated a few days ago. Now the Data Analysis is not showing and I can’t navigate through to Disable UI because i’m using a more updated software. Please help.

  4. Judy says:

    I am using office 365 on a remote server and can find User Configuration -> Administrative Templates but not Microsoft Office under Administrative Templates. Can you help me?

Skip to main content