XLT files will not save as XLS

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

If I open a template from a network drive by starting Excel and using
File>Open 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.
 
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.
 
"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.
 
Many thanks Dave, just what I needed...
John.

Dave Peterson said:
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.
Click to expand...
 
Back
Top