Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

ATP function names are not automatically translated in Excel

View products that this article applies to.


Consider the following scenario:
  • In Microsoft Excel 2013 or Excel 2010, you open a workbook that was created in Microsoft Office Excel 2003 or in earlier versions.
  • The workbook was created in a different language than the language that is used by Excel 2013 or Excel 2010.
In this scenario, Microsoft Excel Analysis ToolPak (ATP) function names are not translated into the new language.

↑ Back to the top


This issue occurs because the Analysis ToolPak is an add-in to Excel. When Excel 2013 or Excel 2010 opens an Excel 97-2003 Workbook (.xls) file, Excel 2013 or Excel 2010 can only translate built-in function names in a workbook. Excel 2013 or Excel 2010 cannot translate the Analysis ToolPak function names. This issue only occurs with Excel 97-2003 Workbook (.xls) files. The issue does not occur with Excel Workbook (.xlsx) or Excel Binary Workbook (.xlsb) formats.

↑ Back to the top


To work around this issue, open the affected workbook in a same-language version of Excel 2013 or Excel 2010. Then, save the workbook as either an .xlsx or .xlsb workbook. When you open this new workbook in a different language version of Excel 2013 or Excel 2010, the Analysis ToolPak function names are translated.

↑ Back to the top

Keywords: KB983034, kbtshoot, kbconversion, kbexpertisebeginner, kbsurveynew, kbpubtypekc, kbprb

↑ Back to the top

Article Info
Article ID : 983034
Revision : 3
Created on : 10/31/2012
Published on : 10/31/2012
Exists online : False
Views : 417