The default template location for MSOffice applications is

C:\Documents and Settings\<username\Application Data\Microsoft\Templates\

The User template location in MS Word is common for MS Office products; if
you change that in MS Word; Excel,Powerpoint and all MSOffice Applications
will take that as the template location. You can try that in Excel or
PowerPoint while you try to change the file type to .xlt/.pptx the default
folder is the same. If you are familar with VBA; you can retreive the
templates path for MS Office using
Application.TemplatesPath

If this post helps click Yes
---------------
Jacob Skaria


"Jim Peterson" wrote:

Hi everyone and thanks in advance for any help you can offer.

I am using XP Pro and Office Pro 2003.

On my hard drive, I have always saved all data files under one directory
called "Data Files". Original name, huh?

Anyhow, under "Data Files" are sub directories for Word, Excel, Publisher,
etc. and then more sub directories as needed. The obvious reason for this is
ease of backup. I only have to backup one directory to capture all of my
created files.

The problem is with my user created templates. In Word, on the menu bar, I
can access Tools|Options|File Locations tab and it will let me specify
(change) the file location for all my Word templates. I now save them all in
my Data Files\Templates\Word directory.

Can I do the same thing in Excel? The only place I can even finds any file
location options is under the Tools|Options|General tab, but I don't see any
way to edit the templates location/directory.

I would like to be able to store my Excel templates in Date
Files\Templates\Excel if that is possible.

Any help or ideas? Thanks again if anybody has any suggestions.

Jim