Where can I save Excel templates .XLT files?

[DC]

Can I save .xlt files to a shared drive or only to a template folder on
c:\? If the latter then each user needs a local copy of the template?
I can only get xlt files to work properly (open as an xls while
preserving the orgibnal xlt) if I save to the local templates folder.
(These are not to be default xlstartup files.)

If I cannot save to a shared drive am I better off making an xls file
with a macro preventing saving as the original name or saving to the
orginal folder?

Thank you in advance.

 

[NickHK]

DC,
Whilst Excel does not expose it, there is a "Workgroup Templates" folder
used by all Office app.
Easiest way is to set it in Word, Tools>Options>File Locations.

Restart Excel and check that the templates are showing up under New.

NickHK

 

[Nigel]

I regularly use a shared network drive for my template files. There is
nothing to prevent you placing an xlt anywhere you can put an xls. Excel
will usually try to save a new template (when you select type xlt) into the
shared office template directory, just change the selection to the shared
drive.
Be aware that the drive letter may not correspond to the network server for
all users. So use a UNC path to get the drive and directory eg something
like..... \\ukcorftp01\marketdata\ , another tip I usually assign the
drive-path to a variable and use that when locating files. This way you can
specify a local drive for development and a network drive for production.