If I understand your question correctly, you want make a template of your
workbook and can you update the database in that template once it has been
made. Yes, in 2 ways. When you select File/New and choose your template,
Excel opens a copy of the template as a workbook, usually with a number
appended to the end of the template name to indicate that it is a copy of
the other file. From this copy you can update and make changes as you wish
to your data. Now you can save these changes to your template. Select
File/Save As and from the list of file types find Template *.xlt. You may
now have to browse to where your templates are stored and overwrite the
original template with the new one.
The other, and more direct way to make changes to a template is to open the
original template, make changes, and just save. When you do File/Open select
file type *.xlt and browse to the Templates folder and open your template.

Tip: Excel templates are stored in different places depending on your
version of Windows and/or Office/Excel. You can open Excel and ask it where
the templates are stored. Open the VBEditor (Alt+F11). There should be a
small window near the bottom named Immediate. If not, hit Ctrl+G. In that
window type:
?application.TemplatesPath
and hit enter. The path is then displayed.

Mike F

"Anthony" wrote in message
...
Hi All
I have a workbook which has 2 worksheets. One worksheet
is a database of employee details and is Hidden.
The other worksheet is from where I use functions to call
the details or to update the database using Form(thanks to
MVP's).
Now I want to know if it is Possible to update the
worksheet One(the one with the database) should I convert
the workbook into a Template???

Thanks for any answers or suggestions.

AJ