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?
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.