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.

Now when you open your workbook, the Solver Task Pane should appear automatically. NOTE: Although the Solver add-in can be used in Excel 2013 and Excel 2016, because your model is solved 'in the cloud,' this Solver add-in works only with Excel workbooks that are stored online.

What is the issue here? How do I go about solving this issue? 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!

How to install note pad for mac os x. 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.

Download quicktime for mac 10.6. This happens on my G5 2x2 and on my PB 12. I have a licence of Sorenson Video Pro 3 Now - when I select the 'Watermark' tab in 'Options' QuickTime CRASHES repeatedly.

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

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.