Help!

Excel Temporary Files Location

 
Post new topic   General Reply to Topic (not reply to a specific post)    Forums Home -> General Discussions RSS
Next:  Inserting Excel worksheets  
Author Message
Frederik
External


Since: Mar 28, 2007
Posts: 2



PostPosted: Wed Mar 28, 2007 10:07 am    Post subject: Excel Temporary Files Location
Archived from groups: microsoft>public>excel>misc (more info?)

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
Back to top
Dave Peterson
External


Since: Jul 08, 2005
Posts: 16264



PostPosted: Wed Mar 28, 2007 1:47 pm    Post subject: Re: Excel Temporary Files Location [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

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
Back to top
Frederik
External


Since: Mar 28, 2007
Posts: 2



PostPosted: Thu Mar 29, 2007 5:09 am    Post subject: Re: Excel Temporary Files Location [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

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
Back to top
Dave Peterson
External


Since: Jul 08, 2005
Posts: 16264



PostPosted: Thu Mar 29, 2007 11:31 am    Post subject: Re: Excel Temporary Files Location [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

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 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

--

Dave Peterson
Back to top
jaf
External


Since: Sep 30, 2003
Posts: 56



PostPosted: Fri Mar 30, 2007 2:31 pm    Post subject: Re: Excel Temporary Files Location [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

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

> 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
>
Back to top
Display posts from previous:   
Post new topic   General Reply to Topic (not reply to a specific post)    Forums Home -> General Discussions All times are: Eastern Time (US & Canada)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum