Smartlist export to Excel cannot find the file.

(0) Share

Report

Posted on by Richard Wheeler

75,848 Moderator

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

All responses (15)

Answers (1)

Elizabeth Hodge 162 on at

Like (0)

Report

RE: Smartlist export to Excel cannot find the file.

Thanks, Stephanie - exactly what I needed for a quick fix.
Community Member on at

Like (1)

Report

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 12,931 on at

Like (0)

Report

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@outloo... 10 on at

Like (0)

Report

RE: Smartlist export to Excel cannot find the file.

Hi Janeece,

have you tried to disable UAC and check it.
Janeece Moreland 270 on at

Like (0)

Report

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 on at

Like (0)

Report

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 4 on at

Like (0)

Report

RE: Smartlist export to Excel cannot find the file.

I have the same issue in GP2013 and I am a domain admin!
Jonathan Fear on at

Like (0)

Report

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 on at

Like (0)

Report

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 75,848 Moderator on at

Like (0)

Report

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.