Update Microsoft Dynamics AX data by using Microsoft Excel

Important

This content is archived and is not being updated. For the latest documentation, see Microsoft Dynamics 365 product documentation. For the latest release plans, see Dynamics 365 and Microsoft Power Platform release plans.

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.

Note

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.

See also

Using the Microsoft Dynamics AX Add-in for Excel

Integrating Microsoft Dynamics AX with Microsoft Office

Microsoft TechNet