Re: Excel Temporary Files Location
- From: Dave Peterson <petersod@xxxxxxxxxxxxxxxx>
- Date: Thu, 29 Mar 2007 07:31:19 -0500
I don't know a way to change this behavior.
The only work-around that I can think of is to copy the workbook to a different
location, work on it there, and when done, copy it back to its real home.
Frederik wrote:
Thanks for you answer Dave,
it'll create a temporary workbook when it savesCan 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 <peter...@xxxxxxxxxxxxxxxx> 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
--
Dave Peterson
.
- References:
- Excel Temporary Files Location
- From: Frederik
- Re: Excel Temporary Files Location
- From: Dave Peterson
- Re: Excel Temporary Files Location
- From: Frederik
- Excel Temporary Files Location
- Prev by Date: Re: New problem
- Next by Date: Re: Cell protection
- Previous by thread: Re: Excel Temporary Files Location
- Next by thread: Re: Excel Temporary Files Location
- Index(es):
Relevant Pages
|
