How to find and install Data Analysis ToolPak or Solver for Excel for Mac
The Data Analysis ToolPak and Solver add-ins are not available in all Microsoft Excel for Mac versions. The following table shows which Excel for Mac versions include these add-ons.
|Version||Data Analysis ToolPak included?||Solver included?|
|Excel 2016 for Mac||Yes||Yes|
|Excel for Mac 2011||No.||Yes, starting with Excel for Mac 2011, Service Pack 1 (version 14.1.0)|
|Excel for Mac 2008||No.||No|
Where to find Data Analysis ToolPak and Solver
If the add-ins are available in the Excel for Mac installation that you are using, follow these steps to locate them:
- Start Excel for Mac.
- Click Tools, and then click Add-Ins.
- Click the Data Analysis ToolPak or Solver option to enable it. Then, click OK.
- Locate Data Analysis ToolPak or Solver on the Data tab.