I am sure this has a simple answer, but I can't figure it out.

I have a spreadsheet that contains 12 months worth of budgets. The upper
left corner of the spreadsheet is NAMEd according to that month/year of the
budget, ie JAN06 - DEC06. I copied several months worth of budgets to a new
sheet and the same NAME was copied too. I tried to rename the appropriate
cells, JANO6 renamed to JAN07 and so forth. However, I cannot get it to take
the new name.

I have tried clicking in the box to the left of the fx window. I have tried
via NAMEDEFINE, but cannot get the new name to take.

Any suggestions?

Thanks,