Compile error in hidden module: SolverCode

Problem: I am using Microsoft Office 365 on Windows 10, but now, when I click on the "Solver" button in the "Data" tab (see image), a "Compile error in hidden module: SolverCode"  error message pops up:

compile error in hidden module: SolverCode

what does this mean?


Resolution: 

We have seen this issue with few users: some did not have NumXL installed. Solver is an add-in that is bundled with Microsoft Office suite, so this issue is an issue with Microsoft Office installation.

See our blog on this topic here: https://www.numxl.com/support/blog/2019/windows-10-cumulative-update-kb4511553

Going forward, to address this issue, we are proposing the following:

  1. Uninstall NumXL from your system (go to classic control panel)
  2. Uninstall Office 365 from your system.
  3. Reboot your system.
  4. Goto Windows Update, and make sure your system is up to date
  5. Install Office 365 (using the online installer from office)
  6. Open Excel, and enable Solver add-in (comes with MS Office)
  7. From the data tab, click on solver to open it.
  8. As soon as Solver opens its window successfully, go ahead and install NumXL (download a new installer from our website)

 

 

Have more questions? Submit a request

0 Comments