That cell has Data Validation which limits between 1 and 30.
Open the *.xlt file directly, not as a new workbook.
Best way to do that is close Excel, browse to the folder the Template is stored
in.
Open the template from there. It will open as *.xlt
Select and Data>Validation. Change to 40 years and OK your way out.
Save the Template.
Gord Dibben MS Excel MVP
Ask a Question
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.