I have Excel 2019. When trying to set up Solver in a worksheet I get the message:

"Compile error in hidden module: Solver Code"

It does show as active in "Active Application Add-ins"

Can someone please tell me what to do to be able to use Solver.

All help greatly appreciated.