Excel Template Question

[Guest]

I built a template in Excel 2000. I would like to force this to open as a
workbook, but every time it opens as a template (if you click save, the
changes are made to the .xlt file).

How do I make it open into a new workbook instead of the template?

I've currently written VBA code to force the user to save the template as a
workbook when the template's opened, but that copies to the new workbook as
well, forcing the user to save the new workbook with a new name.

 

[Gord Dibben]

Sounds like you are opening the template directly.

Where is it located and how do you open it?

If it has been saved as a template(*.xlt) then you should be able to click on
File>New...On My Computer>select the template and open.

Should open as templatename1.

Do your work then File>Save. You will be prompted for a name.

It will save as *.xls


Gord Dibben MS Excel MVP

 

[Guest]

Thanks, Gord.

I've stored the templates into a network folder that various people can open.

I know I can either copy the templates to the individual folders, but these
templates are subject to occasional revision (changes in pay rates,
transfers, etc). The next idea would be to point the users' template folders
to the network folders that contain these templates. I'll have to get with a
Network Admin to edit their login scripts

<begin rant>
Maybe it would be better just to make a master spreadsheet than a template.
I'm trying to sell these folks on using Access instead of Excel, but they
don't want to pay the money...
<end rant>

 

[Guest]

OK - I made a shortcut to the template in the templates folder. This way, we
can update the templates as needed and still use templates as they were
originally intended.

Thanks, Gord! I wouldn't have gotten to this point without your push!

 

[Gord Dibben]

Thanks for the feedback.

Gord