Now on the Data tab, in the Analysis group, you should see the Solver command. In Excel for Macintosh, if you don't see the Solver command on the Tools menu, you need to load the Solver add-in. Click the Tools menu, then click the Add-ins command. In the Add-ins available box, select the Solver.xlam check box.
Active3 years, 8 months ago
opening several examples of written macro's/ codes I suddenly get stuck with a code that seems to be secured. Solver (SOLVER.XLAM)This is doiing noting and I would like to remove that from my system. I guess this is not a relavant code . Can anybody tell me what I should do? I already installed something to remove passwords but the SOLVER is still asking for passwords and I can not get rid of it!
Community♦
user2151190user21511909922 gold badges33 silver badges1515 bronze badges
2 Answers
Solver is Excel add-in. If you want to remove it go to Excel Application > Options > Search for add-ins > Press something like 'go to' button > un-check Solver on the list (I can't give you exact path as I have Polish version of Excel).
![Solver xlam 2010 honda engine Solver xlam 2010 honda engine](/uploads/1/2/6/1/126155205/629943210.png)
It's better not to try to open Solver's VBA code as it is rather copyright protected.
Moreover, I don't think Solver makes any inconveniences when working with Excel or VBA.
Kazimierz JaworKazimierz Jawor17.4k77 gold badges2727 silver badges4848 bronze badges
verry nice, now it is not more active. For the one who want to deactivate this you should follow the next steps. For Excell 2010. Open Excell/go to options/ go to add ins/ go to active add ins on top of the page / select the SOLVER / press start (down the page)/ then a window will pop up so that you can uncheck or check it as you require. That was verry easy to do. Thank you Kaz for pointing me to the right direction! It is better to not delete them, maybe you will need them later
user2151190user21511909922 gold badges33 silver badges1515 bronze badges
Not the answer you're looking for? Browse other questions tagged excel-vbasolvervbaexcel or ask your own question.
Active1 month ago
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?
Bakugan Battle Brawlers Subtitle Indonesia Download Nonton Bakugan Battle Brawlers Sub Indo Streaming online Bakugan Battle Brawlers BD Bluray disc mkv 480p 720p 1080p mp4 HD mini 3gp bahasa terbaru Anime Episode Season 1 Season 2 Season 3 Season 4 Season 5 Season 6 Season 7 Season 8 S1 S2 S3 S4 S5 S6 S7 S8 Tamat END Credit: oploverz, awsub, anitoki, samehadaku, quinime, fansub, kopaja. ![Download anime bakugan battle vestoria sub indo full episode Download anime bakugan battle vestoria sub indo full episode](/uploads/1/2/6/1/126155205/776493272.png)
ashleedawg![Download anime bakugan battle vestoria sub indo full episode Download anime bakugan battle vestoria sub indo full episode](/uploads/1/2/6/1/126155205/776493272.png)
13.8k44 gold badges2828 silver badges6262 bronze badges
TheTreeManTheTreeMan42377 gold badges1818 silver badges3434 bronze badges
5 Answers
Look up This link to understand how it can be done
But essentially you need to unload the addin and reload it , the following code will work
Community♦
Ravi YenuguRavi Yenugu3,39933 gold badges3131 silver badges5454 bronze badges
Solver Xlam 2010 Honda Civic
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
MichaelMichael
Solver Xlam Excel
I have performed below steps to fix Solver.xlam is missing
1 - File -> Options -> Add-Ins
2 - Click on the add ins tab then select 'Manage Excel Add-Ins' at the bottom --- 'GO' Enable these 4 options -> OK
- Analysis Toolpack
- Analysis Toolpack-VBA
- Euro Currency Tool
- Solver Add-in
3 - After that you need to enable Solver reference.Tool -> Reference . Solver Checkbox should select .
sridharnethaAccord Crosstour
sridharnetha92544 gold badges2020 silver badges4646 bronze badges
Maybe not relevant anymore, but for others facing this problem. There seem to be some problems with some users using the 64bit version of office with the solver. Uninstalling this version and downgrading to the 32bit version may solve the problem.
Solver Xlam 2010 Honda V
nblitznblitz
i used to be have a similar issue that i cant find solver.xlam file, so i try to redownload solver.xlam. and it worked, originally solver.xlam is located at c:/program files/microsoft office/office15/library/SOLVER/SOLVER.XLAMif your solver.xlam is not located there, than i think its better to redownload solver.xlam and put it there
HaekalHaekal