Saving a xls as a xlt
papou asked if you really saved the file as a template.
At the bottom of the File|SaveAs dialog, there's a: "Save As Type" box
Did you select "Template (*.xlt)" in that dropdown.
(Change this first, then change the location to your network folder.)
===
If you did this, then when the users open this template, do they get the
template itself (with a name of mytemplate.xlt in the title bar) or do they get
a new workbook based on that template (with a name of mytemplate1 (no extension)
in the title bar)?
Are the users doing File|New to create the new workbook?
===
An alternative. Save your file as mytemplate.xls (just a regular workbook), but
then use windows explorer to mark that file as ReadOnly. It isn't foolproof,
but it's usually sufficient.
ole_ wrote:
Nope, i have tried ten times on differtent paths and the only thing that
works is c:\documents and s...\ole\application data\microsoft\template.
It dont nessesary need to be a XLT file but the user may not have the "save"
option, thats why i would like it to be a XLT file
AHA
Ole
"papou" skrev i en meddelelse
...
Hi
Not sure but it may just be that you do not select the correct file type
when you try Save As?
HTH
Cordially
Pascal
"ole_" a écrit dans le message de
...
Hi,
i am trying to save a xls file as a xlt file, but when i save it on a
network share or "C:\" it don't
function as a XLT file (you can "save" it, it dosn't popup as " save
as"),
but if i save it
in the propper place (c:\documents and s...\ole\application
data\microsoft\template)
it works, is there a way to save it as C:\mytemplate.xlt where it will
function as a xlt file.
AHA.
Ole
--
Dave Peterson
|