Roger:

Thanks for your response. I was not using a list in this case but will keep
your info and link for future reference. Got my immediate answer from
another user. I appreciate your helpful information.

Mary E

"Roger Govier" wrote:

Hi Mary

If the validation is purely text length, then it should work fine. If,
however, there is any data validation which refers to lists, then those
lists would have to be held on the same sheet that is being opened from
the template, or be contained in another workbook that is open when you
are trying to use the data validation in the template.

Take a look at the information on Data Validation on Debra Dalgleish's
site
http://www.contextures.com/xlDataVal05.html


--
Regards

Roger Govier


"Mary E" <Mary wrote in message
...
I have created an Excel Template which contains Data Validation to
limit the
text length. However, when I copy the template to a new worksheet, I
lose
the data validation. How can I maintain this so that a user does not
have to
re-enter the data validation? Thanks!
marye