Re: Can't change a cell name back

  • Thread starter Thread starter Bob Phillips
  • Start date Start date
You can, but it means finding all cells that reference it and changing them,
then delete the name and add a new on.

But the addin is far simpler.

I have no idea about the ratings, I use UseNet, and we don't see that here.
 
But that doesn't delete the original name or change the formulae that refer
to that original name.
 
In Excel 2007, to delete a name, choose Formulas | Name Manager, select the
name from the list, and click the Delete button. To change formulas, choose
Home | Find & Select | Replace ...

- Mike
 
You might want to go back and read the OP's original message in this
thread... unless I am misreading it, he is already familiar with the Name
Manager... he has a side issue with attempting to use it that he wants to be
rescued from.
 
Rick -

I did read the OP's original message before posting, and I concluded that
either she didn't know how to delete a name using the Name Manager, or she
didn't know how to change names that are used in formulas, or both.

So, I was trying to suggest that, instead of trying to use the Name Manager
to change a name directly in a single step, she (a) delete the old undesired
name, (b) define the new name, and (c) replace the old with new in formulas
using Replace.

First she wrote: "...But the Name Manager only shows the one name (MP2OZ).
It does not show ML2OZ."

So she should be able to delete MP2OZ, which is the defined name that she
doesn't want.

Then she wrote: "How can I change this cell to "ML2OZ" and have all of the
formulas
updated?"

After deleting MP2OZ, she should be able to define the desired ML2OZ.

And then she can change formulas by choosing Home | Find & Select | Replace
....

- Mike
 
Square Peg -
But I can't. See my last reply to Rick. <
Click to expand...

Are you saying that you cannot use the Name Manager to delete MP2OZ, define
ML2OZ, and then choose Home | Find & Select | Replace to replace all
instances of MP2OZ with ML2OZ ?

If you can't, what happens or doesn't happen?

The steps I've described do not use the Edit feature of the Name Manager.

Your reply to Rick does not mention using Home | Find & Select | Replace.

- Mike
 
This is very odd.

When I change the name MP2OZ to ML2OZ in the Name box, this effectively
creates two names. The only way I could delete it was to got Name Manager
and delete it. If I the tried to rename MP2OZ to ML2OZ I get the error you
describe. This looks like a bug to me.
 
Back
Top