ÅÝܽ¶ÌÊÓƵ

print friendly version

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.

    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.
  4. Click the Install button.
  5. Once complete you should find the the Data Analysis tool pack and Solver in Excel are in english.

Help us to improve this answer

Please suggest an improvement
(login needed, link opens in new window)

Your views are welcome and will help other readers of this page.

Categories

This is question number 2471, which appears in the following categories:

Created by Gillian Powell on 9 March 2012 and last updated by Mark Wilson on 7 November 2017