Copy data from a grid to Microsoft Excel [AX 2012]

Updated: July 19, 2011

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

You can copy information from some grids in Microsoft Dynamics AX and paste that information into a Microsoft Excel worksheet.

  1. In the grid of the active form, select the rows to copy.

    To select several rows, hold down the CTRL key while clicking the individual rows to select. To select several consecutive rows, select the first row, hold down the SHIFT key, and then click the last row to select. To select all the rows in the grid, click File > Edit > Select all.


    In some grids, you cannot select multiple rows at the same time.

  2. Click File > Edit > Copy to copy the selected rows.

  3. Open a Microsoft Excel worksheet, select the cell where the information should start in the worksheet, and then press CTRL+V to paste the information from the grid in Microsoft Dynamics AX to the worksheet.

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