Did you save it as a template and do the users open it under filenew and
select templates and from there open it? If so it will work, the whole idea
is that you don't open the template but a copy named after the template and
a number
Anyway, it works but with all datavalidation there are restrictions, any
user can copy over values that exceed the limits you put in the validation.
Regardless, even if you are not using a template file and just copy a sheet
with validation it should work

--

Regards,

Peo Sjoblom

Northwest Excel Solutions

www.nwexcelsolutions.com

(remove ^^ from email address)

Portland, Oregon




"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