View Single Post
  #6   Report Post  
florisz florisz is offline
Junior Member
 
Posts: 1
Default

Hi Frederik,
Sorry for replying to this old post, but the problem is still there.
I ran into the same problem while I work with webdav(DMS) with versioning.
Everytime Excel wants to write this temp file and delete it after closing.
I found that Excel 2007 does not make this temp file when you open an 'xls' or when the location is read only. In the latter situation excel will add [read only] in it's header to the file name.
When I open an 'xlsx', Excel 2007 just creates this temp file as soon as you open the file. Not only when you make changes or so.

Indeed, the best workaround is download+reserving the file and edit it localy. After finished upload a new version. It's not what I call very userfriendly.

Florisz

Quote:
Originally Posted by jaf View Post
Hi Frederik,
Sorry. Its hard coded. See http://support.microsoft.com/kb/150368 for Excel.
And this one on Word has a longer explaination
http://support.microsoft.com/kb/211632 Click the "where and when..." link.


--
John
johnf202 at hot mail dot com


"Frederik" wrote in message
oups.com...
Thanks for you answer Dave,

it'll create a temporary workbook when it saves

Can I change this file location? The Excel files are on a NAS device.
This NAS device communicates with an Antivirus Server. We do not want
these temporary files to be sent to the AV server and so it would be
better if the temporary files would be saved on the local machine
instead of on the NAS device.

Kind regards,
Frederik



On Mar 28, 4:47 pm, Dave Peterson wrote:
Excel doesn't do this.

Are you sure it's not your antivirus software.

Excel will store some temporary files in your windows temp folder--and
it'll
create a temporary workbook when it saves, but if that save is
successful, then
that workbook will disappear.

MSWord does create a temporary file in that same folder. It'll start
with a
tilde ~ (IIRC).

Frederik wrote:

Hi all,


When Excel opens a file, it creates a temporary file in the same
directory. This file disappears as soon as the Excel workbook is
closed again. But what if I want these temporary files to be created
in a chosen location, instead of the same directory as where my file
resides?


Thanks for your time and answer!


Frederik


--

Dave Peterson