Freigeben über

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

  • Artikel

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”.

Details:

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

Thanks,
Sam Lester (MSFT)

Comments

  • Anonymous
    May 05, 2017
    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.
    • Anonymous
      May 05, 2017
      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?Thanks,Sam
  • Anonymous
    May 02, 2018
    What happens when you require trusted publishers but the publisher certs expired.
  • Anonymous
    May 05, 2018
    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.
  • Anonymous
    June 07, 2018
    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?