Cannot use Solver Add-in

Question

Cannot use Solver Add-in

Wanqing GAO 15

I downloaded Office 365. After selecting the Solver Add-in, Excel will display an error message as shown below, and the Solver Add-in cannot be used. 屏幕截图 2024-10-09 103451

屏幕截图 2024-10-09 103518

屏幕截图 2024-10-09 103546

屏幕截图 2024-10-09 103612

屏幕截图 2024-10-09 103638

I have conducted multiple online repairs and reinstalled office365, but none of them have resolved the issue.

2 answers

Your answer

Answer 1

Emi Zhang-MSFT 30,046 Microsoft External Staff

Hi,

Did you use 32-bit version or 64-bit version Office and Windows?

I suggest you go to File- Options- Add-ins- select the Solver Add-in and check the location:

User's image

If your computer is 64-bit and the Office is 64-bit, the file locates at:

C:\Program Files\Microsoft Office\Office14\Library\SOLVER\SOLVER.XLAM

64-bit OS & 32-bit Office:

C:\Program Files (x86)\Microsoft Office\Office14\Library\SOLVER\SOLVER.XLAM

Just checking in to see if the information was helpful. Please let us know if you would like further assistance.

If the response is helpful, please click "Accept Answer" and upvote it.

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.

Wanqing GAO 15 Reputation points

2024-10-10T06:26:29.9166667+00:00

Hi，Both my computer and Office are 64-bit, and the file location is correct, but the problem still occurs.
Emi Zhang-MSFT 30,046 Reputation points Microsoft External Staff

2024-10-10T08:30:07.2066667+00:00
Hi,

There are 2 options you need to try:

Please go to Developer tab- open Visual Basic editor- select Tools- select References- make sure the Solver is checked and the location is the same as Add-in option:

Go to File- Options- Trust Center- Trust Center settings- Macro Settings- try to check the option "Enable VBA macros"
Wanqing GAO 15 Reputation points

2024-10-10T08:54:49.7066667+00:00

Hi, the problem seems to be here. My Excel page seems to be missing some options, including Solver. How can I solve it?
Wanqing GAO 15 Reputation points

2024-10-17T05:53:08.1466667+00:00

Hello, I still haven't solved this problem and hope to receive further answers.
Emi Zhang-MSFT 30,046 Reputation points Microsoft External Staff

2024-10-28T08:07:29.8866667+00:00

Hi,

If there is no Solver under VBA References list, it seems the add-in is not enabled.

Did you have WPS in PC before? Sometimes if you don't uninstall completely conflicts of Solver would cause this issue.
Wanqing GAO 15 Reputation points

2024-10-30T07:51:00.12+00:00

I uninstalled WPS and checked SOLVER and Enable VBA macros according to the previous steps, but all the errors still exist and SOLVER still cannot be used. And when I reopened Excel, the SOLAR option in the Visual Basic editor was no longer checked.

Answer 2

Hayden Ingram 0

I had the same problem, but I just figured out a solution.

All I had to do was navigate to the original location of the SOLVER.XLAM file, close all workbooks, and manually run that file. Once I did that it seemed to start working.

Let me know if that works for you.

Share via

Cannot use Solver Add-in

2 answers

Your answer