Cannot run the macro 'SOLVER.XLAM!GetGroupLabel' / Compile error in hidden module: SolverCode fix
Channel: pagzamaphone
Date: 2022-02-19

This is a video outlining how we ran into this very strange issue in excel, essentially every time we tried to install the solver add in we would get the following errors: either 

Cannot execute macro 'SOLVER.XLAMlGetGroupLabel'. This macro may not be present in the current workbook, or all macros may be disabled.

or 

Compile error in hidden module: SolverCode

The resolution ended up being a software conflict with WPS Office, a piece of software that comes preinstalled on Asus computers (in this case it was an Asus laptop)

After uninstalling WPS office and doing a repair of office 365 we still needed to disable the solver add in and re-enable the solver add in before everything worked. 

I hope this helps save at least 1 person some time, as we spent about 3 hours over two days trying to figure this out. :)