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 DataValidation. Change to 40 years and OK your way out.

Save the Template.


Gord Dibben MS Excel MVP

On Sat, 28 Jul 2007 12:50:01 -0700, Cutter
wrote:

How can I change the number of years on the Loan Amortization template? It
will only let me do 30 years and I need to do up to 40 years.