Try Microsoft Edge
A fast and secure browser that's designed for Windows 10
A user is getting the following error (see screen shot below) when trying to export SmartList to Excel. She's never had this issue in the past with this SmartList or others. The issue seems to happen for all SmartLists for this user. Other user's do not have this issue, but other user's have a local installation. This user access Dynamics GP via Remote Desktop Server.
We have tried breaking the SmartList down to a few items to ensure there are no special characters and still get the same error.
Dynamics GP Version: 2013 R2 12.00.2038
Anyone else run into this issue or have suggestions to try? Any advice would be much appreciated.
Thanks for the full information on the environment and problem!
There was a similar thread in the past with no resolution:
This seems to be an error passed back from excel regarding permissions issues, or lack of communication to excel via DDE.
There are some reports that the option in excel in advanced options for
“Ignore other applications that use Dynamic Data Exchange (DDE)” should be unchecked, maybe it is checked for this user?
Try running process monitor to see if any permission issues are occurring when the message comes up.
Just a shot in the dark.. Does the export involve date fields? Check the user's regional settings and use US-EN for the formatting...
Tim, the DDE was the culprit. Thank you so much. Pretty sure I never would have found this without your input.