Update Microsoft Dynamics AX data by using Microsoft Excel [AX 2012]

Updated: February 1, 2013

Applies To: Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2, Microsoft Dynamics AX 2012 Feature Pack, Microsoft Dynamics AX 2012

You can use the Office Add-ins for Microsoft Dynamics AX to export data from Microsoft Dynamics AX to Microsoft Excel. After you export data from Microsoft Dynamics AX forms, lists, and reports to Excel, you can modify the data and import the data back into Microsoft Dynamics AX to update records.

NoteNote

To use the Office Add-in for Excel, the following programs must be installed:

  • Microsoft Excel 2010 or Microsoft Office Excel 2007

  • Office Add-ins for Microsoft Dynamics AX. For more information about installing the Office Add-ins, see Install Office Add-ins.

After you export your data from Microsoft Dynamics AX to an Excel workbook, you can use tools and features in Excel to work in more detail with the exported data. For example, you can filter the data, add formats, and use a PivotTable report to summarize your data query.

Select data to export to Excel

  1. Start Excel.

  2. On the ribbon, on the Dynamics AX tab, click Connection, select the Microsoft Dynamics AX server to connect to, and then click OK.

  3. Click Add Data, select the check box for the data source query to use, and then click OK.

  4. In the left pane, select a default header value to include in your data query.

    You can select the header and then click Insert value, or you can drag the header to the appropriate cell in the Excel worksheet.

    Repeat this step until you have added all the header fields for this data query.

  5. In the left pane, select the field to include in your data query.

    You can select the field and then click Insert column, or you can drag the field to the appropriate cell in the Excel worksheet.

    Repeat this step until you have added all the fields for this data query.

  6. Click Choose parameters, and then select the parameters for the fields that you selected for your data query.

    For example, to create a data query to view all Time and material projects, select Expense.Project.Project type = Time and material.

  7. Click Publish data.

After you save the workbook, the data is updated for recent transactions the next time you open the workbook.


Announcements: To see known issues and recent fixes, use Issue search in Microsoft Dynamics Lifecycle Services (LCS).

Community Additions

ADD
Show: