Home |
Search |
Today's Posts |
|
#1
![]() |
|||
|
|||
![]()
You can put .xls files in the template folder, and they'll be accessable in
the <File <New folder also. So, no need to make .xlt extensions if you wish to open copies from the <Files <New folder. So maybe we're at a semantics discussion here. You probably mentioned indirectly the main topic. How do you open, or, how do you *wish* to open copies of the template for use. -- Regards, RD -------------------------------------------------------------------- Please keep all correspondence within the Group, so all may benefit! ------------------------------------------------------------------- "Dave Peterson" wrote in message ... I understand that technically the fileformat is marked Template vs Workbook, but if I save a workbook as .xls (normal workbook), and then rename it to .xlt (not saving it that way), it sure behaves like a template to me. If I put it in my templates folder, I can use file|new ok. If I double click on it in windows explorer, I get a workbook based on that "workbook/template". I don't see a significant difference between these animals. RagDyer wrote: It really depends on your definition of a template. The context of this thread is pertaining to an Excel Template, where a *copy* is *automatically* opened, and the original is *not*. If you wish, you can call any .xls or .xlt file a template, where you open it, add data, and then "Save As" to a new name, preserving the original in that "round about" way. That is *not* an Excel designated template. -- Regards, RD -------------------------------------------------------------------- Please keep all correspondence within the Group, so all may benefit! ------------------------------------------------------------------- "GregR" wrote in message ... If the file is saved as a template with XLT extention, it is a template no matter where it is saved. Greg "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 -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Looking for Manpower Templete Help | Excel Discussion (Misc queries) |