table doesn't work in 2007

A

april

Col A Col B Col e
interest rate payment
0.05 =PMT(A2/12,E3,-E2) loan amt 350000
0.0525 l oan term 360
0.055
0.0575
0.06
0.0625
0.065

if i use 2003 and clikc Data / Table and input A2 as the column input cell,
the click OK, Col B fills up with the appropriate payments for each rate.
however, if i use 2007, go to Insert, click on Table and insert A2, the table
doesn't fill in. In both cases, i have highlighted cols A & B. any
suggestions?

thanks in advance for your help--
aprilshowers
 
Top