Excel Add-ins

Occasional Visitor

On the excel "tool" bar, the "Excel Add-Ins" is unavailable for me to click (I see it but it's greyed out and I can't select it). I'm trying to add in the "solver" data function, any thoughts on how to make this available or an alternative route to access solver?

1 Reply
Maybe that menu is disabled by the network admin? In my experience, you can still load an add-in like any other excel file (excel's file/open, or double click on it in windows explorer). The file path on my machine is C:\Program Files\Microsoft Office\root\Office16\Library\SOLVER\SOLVER.XLAM. Yours might be similar, if not, you could always search for the file to find exactly where it's located.