Forum Discussion

Jiayi_Wu's avatar
Jiayi_Wu
Copper Contributor
Jan 17, 2024

I can't load Excel Solver

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!

 

  • JKPieterse's avatar
    JKPieterse
    Silver Contributor
    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.

Resources