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.