• ITS home
• Help
• Services
• My IT account
• Security
• About

Questions and answers

2471

Excel 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:

1. From Excel 2013 or Excel 2016, click the File tab, and then click Options.
2. Click Add-Ins and in the Manage box, select Excel Add-ins.
3. Click Go… button.
4. In the Add-Ins available: box, select the Analysis ToolPak check box, and then click OK.
5. After you load the Analysis ToolPak, the Data Analysis command is available in the Analysis group on the Data tab.

If the Data Analysis or Solver command appears in a language other than English (such as Russian or Spanish):

1. Close all Microsoft Office applications.
2. Click the Start button > All Programs > Install Applications.
3. In the Software Center window click Available Software.
4. 
   
   1. If Office 2013 is installed click Excel Solver Language fix for Office 2013 SP1 – Excel Solver Fix – Office 2013 item on the list.
   2. Or if Office 2016 is installed click Excel Solver Language fix for Office 2016 – Excel Solver Fix – Office 2016 item on the list.
5. Click the Install button.
6. Once complete you should find the the Data Analysis tool pack and Solver in Excel are in english.