I believe the main point has been addressed by Dave; how are you opening the
file?
Then, how do you *want* to open the file "copy" to use?
The <File <New folder is usually the easiest way, but that's your choice.
It then must be saved, or linked (shortcut) to the templates folder, or the
folder it's in must be designated as an "auxillary" templates folder using
Word or an XL "alternate start up" folder.
There are many ways to "skin" this cat.
Which way do you want to go?
--
Regards,
RD
--------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit!
-------------------------------------------------------------------
"Datasort" wrote in message
...
RD,
Thanks for your reply. I am saving in a c drive path that is not part of
the MS programs path. Example .. C:\temp
I am also selecting the Templete as the "save file type"
So it looks like the question is ... does a .xlt mean it is a templete or
not ... no matter where the file is saved?
Regards,
Stewart
"RagDyer" wrote:
I believe that Excel 5.0 was the last version of XL, where the .xlt
extension *automatically* created a template.
From then on, at least from XL97 on (not sure of 95), *WHERE* the WB is
saved determines whether or not it's a *true* XL template.
When you went to save your WB, if you expanded the "files of type" box,
and
chose "Template (.xlt)", XL automatically directed the WB to be saved in
the
Windows Template folder, AND, incidentally appended the .xlt extension.
I say incidentally because, even an .xls WB, saved in the Template folder,
becomes a "true" XL template, where a *copy* is able to be accessed in the
<File <New folder, preserving the original from modification.
There are, of course, many other procedures for creating and saving "true"
XL templates, besides just placing them in the Templates folder.
SO ... the pertinent question is ... WHERE is your WB saved, and HOW did
you
save it?
--
HTH,
RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================
"Datasort" wrote in message
...
I have saved an xl file as .xlt extention. When I open up the file it is
not
in templete mode. I am about to save over the templete.
Can you tell me what I am missing
Regards,
Stewart Rogers
|