Hello All,

I hope someone can advise how to stop this.

I have a local drive called L:, and all my users have a file in a folder called monthly tracking.

They update this file everyday, however when they do this it creates some sort of data file every time they do this. The data file does not have an extension, and they very in size. The names of the files appear to be hexadcimal. I just want them to stop. I movedthem to a hidden folder hoping they would just stay there, but they keep replicating.

Anyone else have this problem?
How do I stop it?

Thanks in advance,

Tom

These files are temporary files created while excel was saving the file, and for some reason not deleted. It could be caused by a problem one or more of your users have when trying to save the workbook, but they've never advised you of it.

If you add the extension ".xls" onto the end of one of the files I guarantee you'll be able to open the file in Excel, and view the contents. Just out of interest, how large is this spreadsheet?

HTH,

Ad.

The biggest of these files is 130 kb.
And I think I understand why they are not being deleted, because the users do not have full control over this folder. If I give the users full control over their files, will this fix the issue with the temporary files?

Um...

Possibly. Windows Security is not my strong suit.... Try it, and see if it makes a difference.

Might I suggest you only add "delete" access onto their user rights for that folder though?

HTH,

ad

I actually went into each file and granted user the full control over their file. I will continue to monitor the situation and try other security if this does not resolve it.

Thanks for your help.

Tom