Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Smartlist export to Ex...
Microsoft Dynamics GP (Archived)

Smartlist export to Excel cannot find the file.

(0) ShareShare
ReportReport
Posted on by Richard Wheeler 75,730
After a GP 2013 upgrade we have one user that after she generates a Smartlist and clicks the Excel button, she immediately gets a message stating that the temporary Excel file SL tries to create cannot be found. The path is to her temporary folder. When I check the folder there are no files in it. We even tried logging is as an admin on this computer and the problem remains. It is as if the file never gets created. Any suggestions?

*This post is locked for comments

  • Elizabeth Hodge Profile Picture
    Elizabeth Hodge 162 on at
    RE: Smartlist export to Excel cannot find the file.

    Thanks, Stephanie - exactly what I needed for a quick fix.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Smartlist export to Excel cannot find the file.

    Using  SmartlistEnhancedExcelExport=TRUE  in the Dex.ini points the export to the users documents folder.  I've started using this as a work around b/c export solutions for every favorite just doesn't work.

  • Verified answer
    Redbeard Profile Picture
    Redbeard 12,931 on at
    RE: Smartlist export to Excel cannot find the file.

    Janeece,

    You can use SmartList Export Solutions to define exactly where Excel exports a SmartList to. Export Solutions also allows for the definition of Preparation and Completion macros which can manipulate the data and format of the file before and after the data is passed to Excel.

  • Suggested answer
    babubaskaran@outlook.com Profile Picture
    babubaskaran@outloo... on at
    RE: Smartlist export to Excel cannot find the file.

    Hi Janeece,

    have you tried to disable UAC and check it.

  • Janeece Moreland Profile Picture
    Janeece Moreland 270 on at
    RE: Smartlist export to Excel cannot find the file.

    I had this same issue and here is what I have found.

    IT support put DELTEMP on the server and the user continues to lose their files since the excel export is going to temp.  I have not found away to change the default location of the export yet..  This would solve the issue!

  • Jonathan Fear Profile Picture
    Jonathan Fear on at
    RE: Smartlist export to Excel cannot find the file.

    Again please run a Process Monitor log and see if you get access denied results. Just because you are 'Domain Admin' doesn't mean you can't be restricted to a folder location.

  • ArthurA Profile Picture
    ArthurA 321 on at
    RE: Smartlist export to Excel cannot find the file.

    I have the same issue in GP2013 and I am a domain admin!

  • Jonathan Fear Profile Picture
    Jonathan Fear on at
    RE: Smartlist export to Excel cannot find the file.

    Any update on the resolution? This is a post that is getting a large number of views so we would like to get a confirmed resolution.

  • Jonathan Fear Profile Picture
    Jonathan Fear on at
    RE: Smartlist export to Excel cannot find the file.

    Try running a Process monitor when you do the export and you should be able to see the path. Or if there is a issue during the export PM should be able to give you a idea as well.

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,730 on at
    RE: Smartlist export to Excel cannot find the file.

    Soma, this is the first time I have ever seen this. I had even made sure the folder existed. It must be some Windows security issue. I am turning this one over to their IT staff since they are the ones obsessed with security.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,253 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,188 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans