Nothing happens when using Copy and Paste from Excel to GL in Microsoft Dynamics GP

Symptoms
Nothing happens when using Copy and Paste from Excel to GL in Microsoft Dynamics GP
Cause
This can be caused by:
  • 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


Resolution
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



More information
The above information was taken from this blog article:

GP 2013 R2 - Copy and Paste from Excel to GL – Nothing Happens
https://community.dynamics.com/gp/b/dynamicsgp/archive/2014/08/22/gp-2013-r2-copy-and-paste-from-excel-to-gl-nothing-happens


not working Excel copy/paste feature no activity doesn't work copy paste feature doesn't work
Note This is a "FAST PUBLISH" article created directly from within the Microsoft support organization. The information contained herein is provided as-is in response to emerging issues. As a result of the speed in making it available, the materials may include typographical errors and may be revised at any time without notice. See Terms of Use for other considerations.
Properties

Article ID: 3119802 - Last Review: 05/17/2016 15:48:00 - Revision: 2.0

Microsoft Dynamics GP 2016, Microsoft Dynamics GP 2015, Microsoft Dynamics GP 2013 R2

  • kbmbsmigrate kbsurveynew KB3119802
Feedback