Solver.xlam is missing?
I created a program in Excel 2010 on my PC that relies on the built-in solver for Excel. I made sure it worked on both Excel 2010 and Excel 2013 for PC. I then tried to use this same program on Excel 2011, and ran into an issue.
When I tried to compile the project, it says "Compile Error: Can't find Project or Library".
I remembered this happening on the PC side before I enabled the solver, so I went into Tools -> Add-ins and then enabled the Solver.Xlam.
However, I got the same exact error.
I went into the developer side, and went to Tools -> Reference, and found that Solver.Xlam is missing.
I realized that the address it thinks the solver is at is where the solver is on my PC, but not where it is on OSX. When I search on OSX I find the solver is at /Applications/Microsoft Office 2011/Office/Add-Ins.
So I clicked "Browse" on the bottom and select Solver.Xlam.
I select Solver.Xlam.
But now I get a different error.
After this error pops up, the location it is looking for Solver.Xlam at resets to the previous location.
What is the issue here? How do I go about solving this issue?
Answer
Had similar issues and couldn't FIND how to get SOLVER.xla or SOLVER.xlam back into the Tools refererence when opening in Excel 2013
SOLUTION! I have been very stressed trying to get some VBA macros to work between Windows 7 to Windows 10. (Excel 2013). No amount of searching would work.
I had the "MISSING: SOLVER.XLAM" in the tools/references and couldn't find the NEW solver anywhere using any recommended paths.
I finally: 1- Went to the Excel 2013 Application
2 - Opened File/Options/Add-Ins
3 - On the page with the add ins, I clicked on the bottom "Manage Excel Add-Ins" .. "Go..." and found 4 SOLVER related Add-ins there.
4 - Once these were activated, I was able to RETURN to VBA (Alt-F11) and then the "SOLVER" option was available in the Tools/References!! Added it - my macros now work fine