Re: Can't change a cell name back

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


"Rick Rothstein" <rick.newsNO.SPAM@xxxxxxxxxxxxxxxxxx> wrote in message
news:%23X1hd0JDJHA.3268@xxxxxxxxxxxxxxxxxxxxxxx
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 (MVP - Excel)


"Mike Middleton" <mike@xxxxxxxxxxxxxxxxx> wrote in message
news:%23TgV4iJDJHA.3392@xxxxxxxxxxxxxxxxxxxxxxx
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


"Bob Phillips" <BobNGs@xxxxxxxxxxxxx> wrote in message
news:%236uruuIDJHA.3392@xxxxxxxxxxxxxxxxxxxxxxx
But that doesn't delete the original name or change the formulae that
refer to that original name.

--
__________________________________
HTH

Bob

"Mike Middleton" <mike@xxxxxxxxxxxxxxxxx> wrote in message
news:OzafvVGDJHA.3908@xxxxxxxxxxxxxxxxxxxxxxx
Square Peg -

Is there a way change the name without an add-in utility? <

In Excel 2007, choose Formulas | Define Name, or choose Formulas | Name
Manager | New.

In pre-2007, choose Insert | Name | Define.

- Mike Middleton
http://www.DecisionToolworks.com
Decision Analysis Add-ins for Excel



"Square Peg" <SquarePeg@xxxxxxxxxx> wrote in message
news:98anb4dtnfvc6n0300bp5rudf0jimmkr0r@xxxxxxxxxx
On Mon, 1 Sep 2008 09:19:13 +0100, "Bob Phillips"
<BobNGs@xxxxxxxxxxxxx> wrote:

Get hold of Jan Karel Pietere's NameManager utility,
http://www.jkp-ads.com/OfficeMarketPlaceNM-EN.asp. This allows such
functionality as well as much more.

OK, I'll look into it. Thanks.

Is there a way change the name without an add-in utility?

PS: That website has a little design glitch. Near the bottom, where it
shows the rating, clicking on the stars will actually submit a rating.
I clicked on it thinking it worked like the one on amazon, which takes
you to the ratings. I happened to click on star #4, so it got a rating
of 4. Not good human factors.









.