| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
XLT files will not save as XLS
If I open a template from a network drive by starting Excel and using
FileOpen to find the template and then try to Save As, it always leaves the extension as XLT. If I browse to the template and open it by clicking on it, then Save As it changes the extension to XLS. Any idea why the first method tries to save the file back inot the original template? Thanks, John. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
XLT files will not save as XLS
If you use File|Open to get to that .xlt, then excel _knows_ you want to edit
the template--not a new workbook based on the template. How about using File|New to create the new workbook instead. And Windows/excel is smart enough to know to use New (instead of Open) when double clicking on a .xlt file. If you rightclick on a .xls file in windows explorer, you'll see New and Open listed. But Open is bolded (the default action). If you rightclick on a .xlt file in windows explorer, you'll see New and Open, but New is bolded. John in Chineham wrote: If I open a template from a network drive by starting Excel and using FileOpen to find the template and then try to Save As, it always leaves the extension as XLT. If I browse to the template and open it by clicking on it, then Save As it changes the extension to XLS. Any idea why the first method tries to save the file back inot the original template? Thanks, John. -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
XLT files will not save as XLS
"File" "New" opens an XLS copy of the original template (OriginalName+1, 2, 3
however many active at the moment). You are opening and modifying the original XLT. "John in Chineham" wrote: If I open a template from a network drive by starting Excel and using FileOpen to find the template and then try to Save As, it always leaves the extension as XLT. If I browse to the template and open it by clicking on it, then Save As it changes the extension to XLS. Any idea why the first method tries to save the file back inot the original template? Thanks, John. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
XLT files will not save as XLS
Many thanks Dave, just what I needed...
John. "Dave Peterson" wrote: If you use File|Open to get to that .xlt, then excel _knows_ you want to edit the template--not a new workbook based on the template. How about using File|New to create the new workbook instead. And Windows/excel is smart enough to know to use New (instead of Open) when double clicking on a .xlt file. If you rightclick on a .xls file in windows explorer, you'll see New and Open listed. But Open is bolded (the default action). If you rightclick on a .xlt file in windows explorer, you'll see New and Open, but New is bolded. John in Chineham wrote: If I open a template from a network drive by starting Excel and using FileOpen to find the template and then try to Save As, it always leaves the extension as XLT. If I browse to the template and open it by clicking on it, then Save As it changes the extension to XLS. Any idea why the first method tries to save the file back inot the original template? Thanks, John. -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| save files | Excel Discussion (Misc queries) | |||
| can you automatically save files to two different locations? | Excel Discussion (Misc queries) | |||
| macro save a workbook whilst increasing file no | Excel Worksheet Functions | |||
| can not save office2000 files with new name over network | Excel Discussion (Misc queries) | |||
| problem with save files from office 2003 | Excel Discussion (Misc queries) | |||
Linear Mode
