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. The 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: Windows 10 Cumulative Update (KB4511553)

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

  1. Uninstall NumXL from your system (go to the classic control panel)
  2. Uninstall Office 365 from your system.
  3. Reboot your system.
  4. Go to Windows Update, and make sure your system is up to date
  5. Install Office 365 (using the online installer from the Microsoft office)
  6. Open Excel, and enable Solver add-in (comes with MS Office)
  7. From the data tab, click on the 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)

Comments

Please sign in to leave a comment.

Was this article helpful?
0 out of 1 found this helpful