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
Third-party information disclaimer
Third-party information disclaimer
Third-party information disclaimer
คุณสมบัติ

รหัสบทความ: 2431349 - การตรวจสอบครั้งสุดท้าย: 9 ก.ค. 2015 - ฉบับแก้ไข: 1

คำติชม