I cannot use SOLVER in excel

航 宋 1 Reputation point
2022-04-29T10:46:54.073+00:00

I tried to add SOLVER in excel to finish a work, but it didn't work.
Only showing that Microsoft office access the file SOLVER.XLAM.

Office Development
Office Development
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Development: The process of researching, productizing, and refining new or existing technologies.
3,458 questions
Excel Management
Excel Management
Excel: A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.Management: The act or process of organizing, handling, directing or controlling something.
1,638 questions

3 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Emily Hua-MSFT 27,526 Reputation points
    2022-05-02T08:56:32.37+00:00

    Hi @航 宋

    Welcome to Q&A fourm ~

    > Only showing that Microsoft office access the file SOLVER.XLAM.

    Could you please share us with the error message? You can take a screenshot and past to here.

    I suggest you go to C:\Program Files\Microsoft Office\root\Office16\Library\SOLVER, make sure the Solver.xlam file is there and you can open it for a test. (If you have 32-bit version of Office, you need go to C:\Program Files (x86)\Microsoft Office\root\Office16\Library\SOLVER)

    • If the file is missing, I suggest you copy the Solver.xlam file from other computers with Excel installed and copy it to your computer.
    • Then please go to Excel > Options > Add-ins > Manage, Excel Add-ins > Go, untick the box of "Solver Add-in" first > Click OK. Then restart Excel app, tick the "Solver Add-in" back to check this issue.
    • Besides, you can try to use "Browser" button to find the Solver.xlam and load it.
      198202-5.jpg

    Please also go to File > Options > Trusted Center > Trusted Center Settings > ActiveX Settings > You may choose "Prompt me before enabling all controls with minimal restrictions".
    And then go to Macro Settings under Trusted Center Settings, make sure you have enabled macros.

    Any updates, welcome to post back.

    If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

  2. DO NOT OPEN 0 Reputation points
    2023-08-03T04:01:04.3233333+00:00

    Compile error in hidden module: SolverCode.
    This error commonly occurs when code is incompatible with the version, platform, or architecture of this application. Click
    "Help" for information on how to correct this error.

    I get this error when I try to run solver. I dont get that window to run even calculation

    0 comments
  3. Tanay Prasad 2,105 Reputation points
    2023-08-07T06:33:21.0866667+00:00

    Hi,

    Here are some things you can try-

    1. Try repairing your Office installation. Go to "Control Panel" > "Programs" > "Programs and Features," find Microsoft Office in the list, right-click it, and choose "Change." Then, select the option to repair the installation.
    2. Conflicts with other Excel add-ins can cause issues. Try disabling other add-ins and see if Solver works as expected.
    3. Make sure that your Microsoft Office installation is up-to-date. Sometimes, issues can be resolved by updating to the latest version of Office.

    Best Regards.

    0 comments