|  | Can't change a cell name back | | |
| | | Square Peg |  |
|  Posted: Mon Sep 01, 2008 5:58 am Post subject: Can't change a cell name back |  |
I had a cell named "MP2OZ". It was supposed to be "ML2OZ" for
milliliters to ounces. When I noticed the typo, I selected the cell,
then clicked in the Name Box, and typed the correct name.
As soon as I did it, I realized that this would not change the
formulas that use that name. So, I changed it back (to MP2OZ) and then
opened up the Name Manager (Ctrl+F3) and tried to change MP2OZ to
ML2OZ. The Name Manager says that both the old and new names are
already in use and to choose a different name.
But the Name Manager only shows the one name (MP2OZ). It does not show
ML2OZ.
How can I change this cell to "ML2OZ" and have all of the formulas
updated? |
| |
| | | Bob Phillips | |
| | Posted: Mon Sep 01, 2008 6:19 am Post subject: Re: Can't change a cell name back | |
Get hold of Jan Karel Pietere's NameManager utility,
LINK This allows such
functionality as well as much more.
--
__________________________________
HTH
Bob
"Square Peg" <SquarePeg@Round.Hole> wrote in message
news:597nb4t5rb7mlpspk73kac5i3jmh9vdaej@4ax.com...
| Quote: | I had a cell named "MP2OZ". It was supposed to be "ML2OZ" for
milliliters to ounces. When I noticed the typo, I selected the cell,
then clicked in the Name Box, and typed the correct name.
As soon as I did it, I realized that this would not change the
formulas that use that name. So, I changed it back (to MP2OZ) and then
opened up the Name Manager (Ctrl+F3) and tried to change MP2OZ to
ML2OZ. The Name Manager says that both the old and new names are
already in use and to choose a different name.
But the Name Manager only shows the one name (MP2OZ). It does not show
ML2OZ.
How can I change this cell to "ML2OZ" and have all of the formulas
updated?
|
|
| |
| | | Square Peg | |
| | Posted: Mon Sep 01, 2008 6:38 am Post subject: Re: Can't change a cell name back | |
On Mon, 1 Sep 2008 09:19:13 +0100, "Bob Phillips"
<BobNGs@somewhere.com> wrote:
| Quote: | Get hold of Jan Karel Pietere's NameManager utility,
LINK 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. |
| |
| | | Bob Phillips | |
| | Posted: Mon Sep 01, 2008 8:57 am Post subject: Re: Can't change a cell name back | |
| |  | |
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.
--
__________________________________
HTH
Bob
"Square Peg" <SquarePeg@Round.Hole> wrote in message
news:98anb4dtnfvc6n0300bp5rudf0jimmkr0r@4ax.com...
| Quote: | On Mon, 1 Sep 2008 09:19:13 +0100, "Bob Phillips"
BobNGs@somewhere.com> wrote:
Get hold of Jan Karel Pietere's NameManager utility,
LINK 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. |
|
| |
| | | Mike Middleton | |
| | Posted: Mon Sep 01, 2008 5:02 pm Post subject: Re: Can't change a cell name back | |
| | | |
Square Peg -
| Quote: | 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
LINK
Decision Analysis Add-ins for Excel
"Square Peg" <SquarePeg@Round.Hole> wrote in message
news:98anb4dtnfvc6n0300bp5rudf0jimmkr0r@4ax.com...
| Quote: | On Mon, 1 Sep 2008 09:19:13 +0100, "Bob Phillips"
BobNGs@somewhere.com> wrote:
Get hold of Jan Karel Pietere's NameManager utility,
LINK 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. |
|
| |
| | | Bob Phillips | |
| | Posted: Mon Sep 01, 2008 9:37 pm Post subject: Re: Can't change a cell name back | |
| | | |
But that doesn't delete the original name or change the formulae that refer
to that original name.
--
__________________________________
HTH
Bob
"Mike Middleton" <mike@mikemiddleton.com> wrote in message
news:OzafvVGDJHA.3908@TK2MSFTNGP04.phx.gbl...
| Quote: | 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
LINK
Decision Analysis Add-ins for Excel
"Square Peg" <SquarePeg@Round.Hole> wrote in message
news:98anb4dtnfvc6n0300bp5rudf0jimmkr0r@4ax.com...
On Mon, 1 Sep 2008 09:19:13 +0100, "Bob Phillips"
BobNGs@somewhere.com> wrote:
Get hold of Jan Karel Pietere's NameManager utility,
LINK 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.
|
|
| |
| | | Mike Middleton | |
| | Posted: Mon Sep 01, 2008 11:10 pm Post subject: Re: Can't change a cell name back | |
| | | |
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@somewhere.com> wrote in message
news:%236uruuIDJHA.3392@TK2MSFTNGP03.phx.gbl...
| Quote: | But that doesn't delete the original name or change the formulae that
refer to that original name.
--
__________________________________
HTH
Bob
"Mike Middleton" <mike@mikemiddleton.com> wrote in message
news:OzafvVGDJHA.3908@TK2MSFTNGP04.phx.gbl...
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
LINK
Decision Analysis Add-ins for Excel
"Square Peg" <SquarePeg@Round.Hole> wrote in message
news:98anb4dtnfvc6n0300bp5rudf0jimmkr0r@4ax.com...
On Mon, 1 Sep 2008 09:19:13 +0100, "Bob Phillips"
BobNGs@somewhere.com> wrote:
Get hold of Jan Karel Pietere's NameManager utility,
LINK 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.
|
|
| |
| | | Rick Rothstein | |
| | Posted: Mon Sep 01, 2008 11:42 pm Post subject: Re: Can't change a cell name back | |
| | | |
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@mikemiddleton.com> wrote in message
news:%23TgV4iJDJHA.3392@TK2MSFTNGP03.phx.gbl...
| Quote: | 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@somewhere.com> wrote in message
news:%236uruuIDJHA.3392@TK2MSFTNGP03.phx.gbl...
But that doesn't delete the original name or change the formulae that
refer to that original name.
--
__________________________________
HTH
Bob
"Mike Middleton" <mike@mikemiddleton.com> wrote in message
news:OzafvVGDJHA.3908@TK2MSFTNGP04.phx.gbl...
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
LINK
Decision Analysis Add-ins for Excel
"Square Peg" <SquarePeg@Round.Hole> wrote in message
news:98anb4dtnfvc6n0300bp5rudf0jimmkr0r@4ax.com...
On Mon, 1 Sep 2008 09:19:13 +0100, "Bob Phillips"
BobNGs@somewhere.com> wrote:
Get hold of Jan Karel Pietere's NameManager utility,
LINK 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.
|
|
| |
| | | Mike Middleton | |
| | Posted: Tue Sep 02, 2008 1:19 am Post subject: 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@NO.SPAMverizon.net> wrote in message
news:%23X1hd0JDJHA.3268@TK2MSFTNGP03.phx.gbl...
| Quote: | 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@mikemiddleton.com> wrote in message
news:%23TgV4iJDJHA.3392@TK2MSFTNGP03.phx.gbl...
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@somewhere.com> wrote in message
news:%236uruuIDJHA.3392@TK2MSFTNGP03.phx.gbl...
But that doesn't delete the original name or change the formulae that
refer to that original name.
--
__________________________________
HTH
Bob
"Mike Middleton" <mike@mikemiddleton.com> wrote in message
news:OzafvVGDJHA.3908@TK2MSFTNGP04.phx.gbl...
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
LINK
Decision Analysis Add-ins for Excel
"Square Peg" <SquarePeg@Round.Hole> wrote in message
news:98anb4dtnfvc6n0300bp5rudf0jimmkr0r@4ax.com...
On Mon, 1 Sep 2008 09:19:13 +0100, "Bob Phillips"
BobNGs@somewhere.com> wrote:
Get hold of Jan Karel Pietere's NameManager utility,
LINK 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.
|
|
| |
| | | Square Peg | |
| | Posted: Tue Sep 02, 2008 4:21 am Post subject: Re: Can't change a cell name back | |
On Tue, 2 Sep 2008 00:37:08 +0100, "Bob Phillips"
<BobNGs@somewhere.com> wrote:
| Quote: | But that doesn't delete the original name or change the formulae that refer
to that original name.
|
This is only true if the original name is manually changed first. If I
do it all through the Name Manager, and keep my fingers off the Name
Box, then all is good. |
| |
| Page 1 of 2 .:. Goto page 1, 2 Next | |
|
|
