SmartList export to Excel Run Application Error "[filepath]" returned 29

(0) Share

Report

Posted on by Community Member

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

Office 2013

Anyone else run into this issue or have suggestions to try? Any advice would be much appreciated.

*This post is locked for comments

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Verified answer

Tim Wappat 5,715 on at

Like
a
(1)

Report
Copy link

Link copied!

Thanks for the full information on the environment and problem!

There was a similar thread in the past with no resolution:

community.dynamics.com/.../127776

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.

Tim.

Was this reply helpful? Yes No
Beat Bucher GP Gee... 28,061 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

Hi Valerie,

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...

Was this reply helpful? Yes No
Community Member on at

Like
a
(0)

Report
Copy link

Link copied!

Tim, the DDE was the culprit. Thank you so much. Pretty sure I never would have found this without your input.

Was this reply helpful? Yes No