I can't load Excel Solver

Copper Contributor

Hi,

I tried to addin excel solver, but it doesn't work. It is showed below (Figure 1). I have enabled all macros in the "Trust Centre Setting" and browsed in the address C:\Users\ [My name] \AppData\Roaming\Microsoft\AddIns which has SOLVER.xlsm (Figure 2). However, it still doesn't work. It would be really appreciated if someone can help with it ASAP. Thank you!

Jiayi_Wu_0-1705529987006.png

Jiayi_Wu_1-1705530173942.png

 

1 Reply
There is something wrong with your installation. In a regular Office install, solver is found in a folder like this one:
C:\Program Files (x86)\Microsoft Office\Office14\Library\SOLVER\SOLVER.XLAM
I would close all Office programs, open Settings, Apps and scroll down to Office and click it. Then click Modify and select Online repair.