12/5/2020 Solver Tool Excel For Mac
Solver and Data Analysis Add-ins for Excel for Mac 2016 Bowers, Jimmy Updated November 21. Install Solver Add-in for Excel for Mac 2016. Open Excel for Mac 2016. https://mobikeen839.weebly.com/mac-tool-box-13-drawer-for-sale.html. Go to the Tools.
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.
Solver In Excel For Mac
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?
ashleedawg
13.8k44 gold badges2828 silver badges6262 bronze badges
TheTreeManTheTreeMan
42377 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♦
evenprimeevenprime
3,39933 gold badges3131 silver badges5454 bronze badges
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.
Microsoft Excel For Mac
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
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
3 - After that you need to enable Solver reference.Tool -> Reference . Solver Checkbox should select .
sridharnethasridharnetha
92544 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. Clean up tool for outlook on mac.
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
Not the answer you're looking for? Browse other questions tagged excelvbaexcel-2013excel-vba-macexcel-2011 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. Mag tool for macbook.
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?
![]()
13.8k44 gold badges2828 silver badges6262 bronze badges
Microsoft Office For MacTheTreeManTheTreeMan
42377 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♦
evenprimeevenprime
3,39933 gold badges3131 silver badges5454 bronze badges
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
Where Is Solver In Excel
MichaelMichael
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
3 - After that you need to enable Solver reference.Tool -> Reference . Solver Checkbox should select .
sridharnethasridharnetha
92544 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.
How To Install Solver In Excel
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
Solver In Excel Macbook
HaekalHaekal
Not the answer you're looking for? Browse other questions tagged excelvbaexcel-2013excel-vba-macexcel-2011 or ask your own question.Comments are closed.
|
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |