Solver for Excel 2016 Missing

Joshua Reynolds 1 Reputation point
2021-04-14T02:30:51.223+00:00

Hi,
I am working in a corporate environment and we are trying to get Solver to load. Running Office 2016 32bit on Windows 10

  • I can confirm the SOLVER.XLAM and SOLVER32.DLL are in C:\Program Files (x86)\Microsoft Office\Office16\Library\SOLVER
  • I have tried repairing office
  • I can confirm the excel addin is active and I have tried multiple times to drop and re add the plug in and restart the application
  • I can see the plug in load on the startup splash before going into the application
  • I've ensured all macros can run

There is still no sign of the expected "Analysis" group under the Data Tab or the Solver app, if I bring up all command in the custom ribbon option there is NO solver command to run

We have Application Whitelisting in our environment but I've put in a bypass, we have antivirus in place but I'm not seeing any warning or errors or blocks. Normally Macro's would be disabled but for testing purposes I've temporary allowed them to run as it would appear from glancing at the software and guide online it would be running as a macro.

Are there any other security settings which might stop this from loading? are there any logs I can look at to get a better idea on why just nothing shows?
I've also tried adding the other default Excel addins that should be in the analysis grouping and none of them show.

Excel Management
Excel Management
Excel: A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.Management: The act or process of organizing, handling, directing or controlling something.
1,639 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Emily Hua-MSFT 27,526 Reputation points
    2021-04-14T09:25:48.743+00:00

    @Joshua Reynolds

    Have other colleagues in the company encountered the same problem? Generally, we try to search logs if Excel crashes or we see any error message about Excel.

    Please go to File > Options > Trusted Center > Trusted Center Settings > ActiveX Settings > You may choose "Prompt me before enabling all controls with minimal restrictions".
    And go to Add-ins, ensure you do not tick the box of "Disable all Application Add-ins".

    Besides, you may go to Registry Editor, delete Computer\HKEY_CURRENT_USER\Software\Microsoft\Office\16.0\Excel, then restart Excel to have a look.
    (Important! Follow the steps in this section carefully. Serious problems might occur if you modify the registry incorrectly. Before you modify it, back up the registry for restoration in case problems occur. )

    If the steps above does not work, I suggest you uninstall Office and reinstall it to check this issue.
    If conditions permit, you could install the 64-bit Office.

    If an Answer is helpful, please click "Accept Answer" and upvote it.
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    0 comments