XLT files will not save as XLS

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.
 
D

Dave Peterson

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.
 
G

Guest

"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.
 
G

Guest

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top