When ‘Export to Excel’ Doesn’t Work

The “Export to Excel” feature that’s been in many Microsoft Dynamics 365 versions is a useful tool that allows users to export the contents of a form grid to an Excel workbook. This feature allows users to get specific AX data into a spreadsheet format where Excel functions can be used. Some users also may be more comfortable and familiar with using Excel for data analysis.

When Dynamics 365 for Operations is installed, there may be some unseen difficulty when first trying to use Export to Excel. For some users, the dropdown from the Office icon in the D365 toolbar may only show “No options” when clicked:

 Office icon d365 toolbar

If you encounter this, navigate to System Administration > Setup > Office app parameters:

Office app parameters

Once the form loads, on the “App parameters” tab, click the “Initialize app parameters” button and accept the pop-up message. After the process completes, there’ll be a new record in the grid with an App ID:

Initialize app parameters

Close your browser and reload the Dynamics 365 for Operations environment. The Export to Excel functionality now will appear when clicking the Office icon on the D365 toolbar in the internet browser:

Export excel in toolbar

Note:  In some instances, the browser may need to be closed and reopened twice after initializing the app parameters for the Export to Excel feature to properly function.

Kate & Ben — How can we help you? Contact Us!

How can we help you?