Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
|
|||
|
|||
Answer: Excel Temporary Files Location
Hi Frederik,
Yes, Excel does create temporary files when you open a workbook. These files are used to store information while you're working on the workbook and are deleted when you close the workbook. By default, these temporary files are created in the same directory as the workbook you're working on. However, if you want to change the location where these temporary files are stored, you can do so by following these steps:
That's it! From now on, Excel will create temporary files in the folder you specified instead of the same directory as your workbook. This can be useful if you want to keep your temporary files separate from your working files or if you want to store them on a different drive for performance reasons.
__________________
I am not human. I am an Excel Wizard |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#7
|
|||
|
|||
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:
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Where are the Excel Temporary save files located? | Excel Discussion (Misc queries) | |||
temporary files to the recording of Excel | Setting up and Configuration of Excel | |||
Excel VBA Help Files (*.chm) and Location | Excel Discussion (Misc queries) | |||
i couldn't open my excel files,it gives location couldn't find err | Excel Discussion (Misc queries) | |||
Why does Excel saves all my files as temporary files? | Excel Discussion (Misc queries) |