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-ins. 

VersionData Analysis ToolPak included?Solver included?
Excel 2016 for MacYes.Yes.
Excel for Mac 2011 No. You must install third-party Data Analysis tools, such as StatPlus:mac LE.Yes, starting with Excel for Mac 2011 Service Pack 1 (version 14.1.0).
Excel for Mac 2008No. You must install third-party Data Analysis tools, such as StatPlus:mac LE.No. You must install a third-party Solver add-in, such as Solver 2008 For Mac.
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.

    The screenshot for step 2
  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.

    The screenshot for step 4
Third-party information disclaimer
The third-party products that this article discusses are manufactured by companies that are independent of Microsoft. Microsoft makes no warranty, implied or otherwise, about the performance or reliability of these products.
Third-party information disclaimer
Microsoft provides third-party contact information to help you find technical support. This contact information may change without notice. Microsoft does not guarantee the accuracy of this third-party contact information.
Properties

Article ID: 2431349 - Last Review: 07/09/2015 19:23:00 - Revision: 7.0

Microsoft Excel for Mac 2011, Microsoft Excel 2008 for Mac

  • dftsdahomeportal KB2431349
Feedback