Using Export To Excel in Dynamics AX to Create Reporting Data Sources

The Export to Excel button may not seem like the most impressive feature of Dynamics AX, but don’t be fooled. If you look closely, you will notice that the when the data is exported to Excel, the data is still linked to Dynamics AX through the Excel Add-In, which means that once it is in your workbook, you can refresh it at any time without having to re-export. Also, if you want to add additional fields after the export from AX, then you can do that directly from Excel. This means that you ca...