Data Analysis ToolPak or Solver for Excel on a Mac

How to find and install Data Analysis ToolPak or Solver for Excel for Mac


Summary

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:


  1. Start Excel for Mac.
  2. Click Tools, and then click Add-Ins.
  3. Click the Data  Analysis ToolPak or Solver option to enable it. Then, click OK.
  4. Locate Data Analysis ToolPak or Solver on the Data tab.