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.

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

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.

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