FIX: "Type of property must be a Dimension" error when you try to import data by using the Excel Add-in in Microsoft Dynamics AX 2012 R2

This article applies to Microsoft Dynamics AX 2012 R2 for all regions.


Consider the following scenario:
  • You use the Microsoft Dynamics AX Add-in for Excel in Microsoft Dynamics AX 2012 R2 to import data into Microsoft Dynamics AX.
  • You add a table by using the Add Data button in the Dynamics AX ribbon in Excel.
  • You bind several fields. This includes one or more dimension fields.
  • You update the data in one of the dimension fields.

In this scenario when you publish the changes in the workbook, you receive the following error message:

Type of property must be a Dimension


Hotfix information

A supported hotfix is available from Microsoft. There is a "Hotfix download available" section at the top of this Knowledge Base article. If you are encountering an issue downloading, installing this hotfix, or have other technical support questions, contact your partner or, if enrolled in a support plan directly with Microsoft, you can contact technical support for Microsoft Dynamics and create a new support request. To do this, go to the following Microsoft website:You can also contact technical support for Microsoft Dynamics by telephone by using these links for country specific telephone numbers. To do this, go to one of the following Microsoft websites:

PartnersCustomersIn special cases, charges that are ordinarily incurred for support calls may be canceled if a Technical Support Professional for Microsoft Dynamics and related products determines that a specific update will resolve your problem. The usual support costs will apply to any additional support questions and issues that do not qualify for the specific update in question.

Installation information

See How to install a Microsoft Dynamics AX hotfix for information about how to install this hotfix.


You must have Microsoft Dynamics AX 2012 R2 installed to apply this hotfix.

Restart requirement

You must restart the Application Object Server (AOS) service after you apply this hotfix.

File information


Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.

Note This is a "FAST PUBLISH" article created directly from within the Microsoft support organization. The information contained herein is provided as-is in response to emerging issues. As a result of the speed in making it available, the materials may include typographical errors and may be revised at any time without notice. See Terms of Use for other considerations.

ID do Artigo: 2792981 - Última Revisão: 17 de fev de 2017 - Revisão: 2

Microsoft Dynamics AX 2012 R2