I think it's more of a "how you're opening the template" that's the problem.

If you do a file|open on that *.xlt file, excel will think you really want to
modify the template.

But if you store the *.xlt in your Templates folder (or even put a shortcut to
the real template workbook), then you can use File|new and get a new workbook
based on that template.

Another option is to not use Excel.

Use windows explorer to get to the folder that holds the *.xlt file. Then
double click on it. Windows/Excel should be smart enough to create a new
workbook based on that template. (If you still open the real template, it's a
windows tweak to fix it.)

Or....

You can also just rightclick on any excel file (xlt or xls) and choose New
(instead of Open) to create a new workbook based on that existing file.

And until you get your solution working, use windows explorer and mark your
*.xlt file as readonly. That'll stop people (including you) from saving over
the file.

====
I usually don't create templates. I just save them as .xls and mark them
readonly. Seems to serve the same purpose for me.

(But I keep a backup--just in case someone gets fancy and fiddles with my
readonly attributes.)

Datasort wrote:

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