- The Open XML SDK 2.0 is not installed
- The Dex.ini has a setting preventing GP from opening the Open XML SDK 2.0
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.
GP 2013 R2 - Copy and Paste from Excel to GL – Nothing Happens
Article ID: 3119802 - Last Review: 17 May 2016 - Revision: 1