Redirect Excel Temp Files

[mpadgett]

Does anyone know if the Excel Temp Files can be redirected to a different folder?

I have a custom Excel VBA spreadsheet that users of a particular Domain group have read/write access to but I've removed the ability to delete.

The problem is that since the temp files are located in the same folder as the actual file being edited, the temp files don't get deleted when Excel closes.

Thanks for any suggestions.