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.
|Version||Data Analysis ToolPak included?||Solver included?|
|Excel 2016 for Mac||Yes.||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 2008||No. 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.|
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.
Номер статьи: 2431349 — последний просмотр: 9 июля 2015 г. — редакция: 1
Microsoft Excel 2011 for Mac, Microsoft Office Excel 2008 for Mac