2471Excel Analysis ToolPak is missing or appears in a language other than English The Analysis ToolPak is a Microsoft Excel add-in program. To use it in Excel 2013 or Excel 2016, you need to load it first:. From Excel 2013 or Excel 2016, click the File tab, and then click Options. Click Add-Ins and in the Manage box, select Excel Add-ins. Click Go button. In the Add-Ins available: box, select the Analysis ToolPak check box, and then click OK. After you load the Analysis ToolPak, the Data Analysis command is available in the Analysis group on the Data tab.
Excel provides a number of data analysis tools, which are accessible via Data > Analysis|Data Analysis. If this option is not visible you may need to first install Excel’s analysis tool pack. This is done by selecting Office Button > Excel Options > Add-Ins in Excel 2007 or File > Help|Options.
If the Data Analysis or Solver command appears in a language other than English (such as Russian or Spanish):. Close all Microsoft Office applications. Click the Start button All Programs Install Applications. In the Software Center window click Available Software. If Office 2013 is installed click Excel Solver Language fix for Office 2013 SP1 – Excel Solver Fix – Office 2013 item on the list. Or if Office 2016 is installed click Excel Solver Language fix for Office 2016 – Excel Solver Fix – Office 2016 item on the list.
![Excel Excel](/uploads/1/2/5/4/125446383/246216468.jpg)
Click the Install button. Once complete you should find the the Data Analysis tool pack and Solver in Excel are in english.
I teach statistics at a university and use EXCEL. My MAC/Apple student users can't find the Data Analysis Tool Pack. I have looked and found one reference to MAC EXCEL 2001 for installing KB276444 which is no longer supported (see below). Does this mean that there is no Data Analysis Took Pack for MAC? Access the data analysis tools To access the data analysis tools, follow these steps:. On the Tools menu, click Data Analysis.
Note If the Data Analysis command is unavailable on the Tools menu, see the 'Install and load the Analysis ToolPak' section. In the Analysis Tools box, click the tool you want to use. Enter the input range and the output range, and then select the options that you want. Install and load the Analysis ToolPak If the Data Analysis command is unavailable on the Tools menu, you must install and load the Analysis ToolPak.
![Microsoft Microsoft](/uploads/1/2/5/4/125446383/664150617.png)
To do this, follow these steps:. On the Tools menu, click Add-Ins. Click to select the Analysis ToolPak check box, and then click OK. If the Analysis ToolPak check box is not listed in the Add-Ins dialog box, you must use the Value Pack Installer to install the Analysis ToolPak. For more information about how to install Value Pack components, click the following article number to view the article in the Microsoft Knowledge Base.