Solved: Unable to change the name of this cell

[doctortt]

I don't know what's going on. I named this cell TEST, and I now want to change it to something else. However, every time I enter and new name and press enter, it goes back to TEST. What did I do wrong?

I opened a new spreadsheet, and I was able the name of a cell back and forth without any problem.

[doctortt]

Fixed it in formula manager. thanks anyway.

[RonMcK]

After you open Name Manager, have you tried Deleting the name TEST, before you attempt to define and apply your new name to that cell?

Oh! I see our posts passed in cyber space.

P.S. Since it's resolved, please mark your thread as Solved (see Thread Tools, accessed from IE).

Cheers,

[mdmackillop]

FYI Each sheet can contain the same range name. If a name is used once, it generally as the scope of the workbook.