To enable Solver, click ‘Tools’ then ‘Addins’. Within the Addin box, check ‘Solver.xlam’ then hit ‘OK’. To use Solver, start Excel 2011 and create or open your workbook. When you're ready to use Solver, click the Solver button on the Data tab (the bundled version of Solver doesn't use the menu Tools Solver.).
- Solver for Excel 2011 1.0 for Mac is available as a free download on our software library. Our built-in antivirus checked this Mac download and rated it as virus free. Solver for Excel 2011 for Mac lies within Business Tools, more precisely General.
- Load the Solver Add-in in Excel. In Excel 2010 and later, go to File Options. Note: For Excel 2007, click the Microsoft Office Button, and then click Excel Options. Click Add-Ins, and then in the Manage box, select Excel Add-ins. In the Add-Ins available box, select the Solver Add-in.
Solver was added to Microsoft Office for Mac 2011 in Service Pack 1. You can download and install Office for Mac 2011’s Service Pack 1 by clicking on the link below:
When you have installed Service Pack 1 (SP1), follow these steps to start Solver:
a. Start Excel.
b. Click Tools -> Select Add-Ins.
c. Click to select the check box for Solver.Xlam.
d. Click OK.
Download Excel For Mac
The Data Analysis Toolpak was removed in Mac:Office for Mac 2008. However, you can download a free third-party tool that offers similar functionality: