Load and activate the Analysis ToolPak. Click the File tab, click Options, and then click the Add-Ins category. If you're using Excel 2007, click the Microsoft Office Button, and then. In the Manage box, select Excel Add-ins and then click Go. If you're using Excel for Mac, in the file menu go. The Excel Data Analysis toolpak shouldbe enabled by default on every lab computer and computer available for checkout from the library. However, someone may have gone through and disabled the Toolpak for whatever reason, or the machine may have been overlooked by the computer tech staff (accidents happen; we're only human).
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:
Excel Data Analysis Tool Mac
When you have installed Service Pack 1 (SP1), follow these steps to start Solver:
How To Download Analysis Toolpak For Excel Mac
a. Start Excel.
b. Click Tools -> Select Add-Ins.
c. Click to select the check box for Solver.Xlam.
d. Click OK.
b. Click Tools -> Select Add-Ins.
c. Click to select the check box for Solver.Xlam.
d. Click OK.
Excel Analysis Toolpak Office 365
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: