question

JoshuaReynolds-6825 avatar image
0 Votes"
JoshuaReynolds-6825 asked emilyhua-msft answered

Solver for Excel 2016 Missing

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.



office-excel-itpro
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

emilyhua-msft avatar image
0 Votes"
emilyhua-msft answered

@JoshuaReynolds-6825

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.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.