<div>
<div class="content wysiwyg-content">
I have users with Excel 2003 and Excel 2007 who open up 10Mb files on a remote server via a mapped drive. Once opening the files they crerate a temp file in the same directory as the file they open and this seems to slow them down. All recovery and file save options are turned off but the file is still created.<br />
<br />
is there any way to stop these temp files being created there or can they be created locally as the link to the server is small and slow.<br />
<br />
Thanks Phil
</div>
</div>


I have users with Excel 2003 and Excel 2007 who open up 10Mb files on a remote server via a mapped drive. Once opening the files they crerate a temp file in the same directory as the file they open and this seems to slow them down. All recovery and file save options are turned off but the file is still created.

is there any way to stop these temp files being created there or can they be created locally as the link to the server is small and slow.

Thanks Phil

Excel temp files created on a mapped drive

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.