excel amortization schedule issue

the excel amortization schedule will only calculate through payment 10, with the "actual number of payments"  defaults to 11.  I can change that number to the real actual number of payments, but the ...