A Microsoft Excel forum. ExcelBanter

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » ExcelBanter forum » Excel Newsgroups » Excel Discussion (Misc queries)
Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

Excel Temporary Files Location



 
 
Thread Tools Display Modes
  #1  
Old March 28th 07, 02:07 PM posted to microsoft.public.excel.misc
Frederik[_2_]
external usenet poster
 
Posts: 2
Default Excel Temporary Files Location

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

Ads
  #2  
Old March 28th 07, 03:47 PM posted to microsoft.public.excel.misc
Dave Peterson
external usenet poster
 
Posts: 35,220
Default Excel Temporary Files Location

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
  #3  
Old March 29th 07, 09:09 AM posted to microsoft.public.excel.misc
Frederik[_2_]
external usenet poster
 
Posts: 2
Default Excel Temporary Files Location

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


  #4  
Old March 29th 07, 01:31 PM posted to microsoft.public.excel.misc
Dave Peterson
external usenet poster
 
Posts: 35,220
Default Excel Temporary Files Location

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
  #5  
Old March 30th 07, 03:31 PM posted to microsoft.public.excel.misc
jaf
external usenet poster
 
Posts: 300
Default Excel Temporary Files Location

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

>



  #6  
Old February 11th 11, 11:04 AM
florisz florisz is offline
Junior Member
 
First recorded activity by ExcelBanter: Feb 2011
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

>
 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Where are the Excel Temporary save files located? nitsa Excel Discussion (Misc queries) 4 February 4th 07 08:00 PM
temporary files to the recording of Excel guillaume Setting up and Configuration of Excel 0 June 27th 06 11:50 AM
Excel VBA Help Files (*.chm) and Location [email protected] Excel Discussion (Misc queries) 1 May 24th 06 05:20 PM
i couldn't open my excel files,it gives location couldn't find err Hozefa Excel Discussion (Misc queries) 1 December 21st 05 04:06 PM
Why does Excel saves all my files as temporary files? Arija Excel Discussion (Misc queries) 2 December 7th 04 11:38 PM


All times are GMT +1. The time now is 08:35 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.
Copyright 2004-2014 ExcelBanter.
The comments are property of their posters.