Forum Discussion

danielt9402's avatar
danielt9402
Copper Contributor
Jun 23, 2025

Compile error in Hidden Module: SolverCode

Hi y'all,

 

As the title says, I keep getting this error whenever I try to use solver. I've tried redownloading microsoft office, but this didn't fix the issue. Any advice?

excel
office 365

3 Replies

  • ForensicE's avatar
    ForensicE
    Copper Contributor
    Mar 04, 2026

    ...Update! I found another suggestion on-line about Enabling Active X Controls; in Excel go to Options>Trust Center>Trust Settings "Enable all controls" then restart excel.  This resolved the issue but is it safe to have all controls enabled like this?

  • ForensicE's avatar
    ForensicE
    Copper Contributor
    Mar 04, 2026

    Hi Nikolino. I also have this problem and have tried all your recommendations with no success, including Online Repair.

    When I open old Workbooks, Solver works ok, but if I open a new sheet in the old Workbook or I open a new Workbook, I get the compile error when I try to open Solver. So I can only use Solver in old work sheets in old workbooks. Any idea how I can resolve this? I've tried everything you mentioned above.  Thanks.

  • NikolinoDE's avatar
    NikolinoDE
    Platinum Contributor
    Jun 25, 2025

    You should not be seeing a Compile error in hidden module: SolverCode. That error usually means something is broken or corrupted in the Solver add-in or its related macro files.

     

    Disable and Re-enable the Solver Add-in

    This often clears the corrupted reference.

    1. Open Excel
    2. Go to File → Options → Add-ins
    3. At the bottom, next to Manage, choose Excel Add-ins and click Go...
    4. Uncheck "Solver Add-in"
    5. Click OK
    6. Go back and re-check "Solver Add-in" to re-enable it

    Then close Excel completely and reopen it.

    Or…

    Delete Corrupt Solver VBA Components (if they exist)

    You may have a corrupt file like SolverCode.bas or a leftover macro.

    1. Open Excel
    2. Press Alt + F11 to open the Visual Basic for Applications (VBA) editor
    3. Look in the Modules area for anything named SolverCode
    4. If it's there, right-click and remove it
    5. Close the VBA editor and try using Solver again

     

    If the issue persists Repair Office 365

    Go to Control Panel → Programs → Programs and Features

    Find Microsoft 365 → click Change

    Choose Quick Repair

    If that doesn’t work, try Online Repair

    Sometimes Excel caches control settings that can corrupt Solver.

    1. Press Windows + R to open Run
    2. Type:

    %appdata%\Microsoft\Forms 

         3. Delete all .exd files there

    Then relaunch Excel and try Solver again.

     

    I hope I could help