Review the below troubleshooting tips below to see which method applies:
Method 1 - On your workstation, click on the
Start (windows) icon in the lower left corner, type in
Programs and Features. Review the list of installed products to make sure
Open XML SDK 2.0 for Microsoft Office is listed. If it is not listed, you will need to install it.
Method 2 - Browse out to your GP code folder (default location is
C://Program Files (x86)/Microsoft Dynamics/Data) and right click on the
Dex.ini file and open it with Notepad. Look for the following setting in your Dex.ini and either remove it or set it to FALSE. This setting was used with the old COM Object model, and doesn't allow GP to open the Open XML SDK 2.0 which it needs to in order to paste the information from Excel to the journal entry.
UseCOMForExcelExport=TRUE
should be:
UseCOMForExcelExport=FALSE