I have a sheet containing a number of named cells. When I make a copy of the
sheet inside the same excel file some names are absolute (reference the cell
in the first sheet) while others are relative (same cell location but in the
new sheet). How can I control or change what each name does?

I'm not sure I understand.

Are you saying that when you copy a worksheet that contains ranges that are
named, then the new sheet has the same name that points back to the original
worksheet?

Or are you describing the behavior of names in formulas in cells on the
worksheet.

In either case, maybe an example of what you mean would make it more clear
(well, for me anyway).

And no matter what you're doing...

If you're working with names, get Jan Karel Pieterse's (with Charles Williams
and Matthew Henson) Name Manager:

You can find it at:
NameManager.Zip from http://www.oaltd.co.uk/mvp

It'll make working with names much easier.



NHMM wrote:

I have a sheet containing a number of named cells. When I make a copy of the
sheet inside the same excel file some names are absolute (reference the cell
in the first sheet) while others are relative (same cell location but in the
new sheet). How can I control or change what each name does?

--

Dave Peterson

I am not talking about the performance of names in formulas but where the
names tie back to.

For Example:
In Sheet "ENG(1)"
I have the following names:
Ta = Cell A1 (In ENG(1))
Tf = Cell A2 (In ENG(1))
Tm = Cell A3 (In ENG(1))

If I right click on the ENG(1) tab and select Move or Copy / Create A Copy
and make a copy of this sheet in the same Excel Document I get the following
names in the new sheet (By choosing Insert Name Define while in the new
sheet)

New Sheet is named ENG(2)
Ta = Cell A1 (In ENG(1))
Tf = Cell A2 (In ENG(2))
Tm = Cell A3 (In ENG(2))

Notice that Ta still reference the first sheet (ENG(1)) while the other two
moved their reference to ENG(2)

I hope that makes sense.

I will check out the name manager - thanks


"Dave Peterson" wrote:

I'm not sure I understand.

Are you saying that when you copy a worksheet that contains ranges that are
named, then the new sheet has the same name that points back to the original
worksheet?

Or are you describing the behavior of names in formulas in cells on the
worksheet.

In either case, maybe an example of what you mean would make it more clear
(well, for me anyway).

And no matter what you're doing...

If you're working with names, get Jan Karel Pieterse's (with Charles Williams
and Matthew Henson) Name Manager:

You can find it at:
NameManager.Zip from http://www.oaltd.co.uk/mvp

It'll make working with names much easier.



NHMM wrote:

I have a sheet containing a number of named cells. When I make a copy of the
sheet inside the same excel file some names are absolute (reference the cell
in the first sheet) while others are relative (same cell location but in the
new sheet). How can I control or change what each name does?

--

Dave Peterson

I couldn't reproduce those results in my testing.

On the new worksheet, each of the names was changed to a sheet level name, like:
'Eng(2)'!Ta

If you try it in a brand new worksheet in a brand new workbook, can you
reproduce it?

NHMM wrote:

I am not talking about the performance of names in formulas but where the
names tie back to.

For Example:
In Sheet "ENG(1)"
I have the following names:
Ta = Cell A1 (In ENG(1))
Tf = Cell A2 (In ENG(1))
Tm = Cell A3 (In ENG(1))

If I right click on the ENG(1) tab and select Move or Copy / Create A Copy
and make a copy of this sheet in the same Excel Document I get the following
names in the new sheet (By choosing Insert Name Define while in the new
sheet)

New Sheet is named ENG(2)
Ta = Cell A1 (In ENG(1))
Tf = Cell A2 (In ENG(2))
Tm = Cell A3 (In ENG(2))

Notice that Ta still reference the first sheet (ENG(1)) while the other two
moved their reference to ENG(2)

I hope that makes sense.

I will check out the name manager - thanks

"Dave Peterson" wrote:

I'm not sure I understand.

Are you saying that when you copy a worksheet that contains ranges that are
named, then the new sheet has the same name that points back to the original
worksheet?

Or are you describing the behavior of names in formulas in cells on the
worksheet.

In either case, maybe an example of what you mean would make it more clear
(well, for me anyway).

And no matter what you're doing...

If you're working with names, get Jan Karel Pieterse's (with Charles Williams
and Matthew Henson) Name Manager:

You can find it at:
NameManager.Zip from http://www.oaltd.co.uk/mvp

It'll make working with names much easier.



NHMM wrote:

I have a sheet containing a number of named cells. When I make a copy of the
sheet inside the same excel file some names are absolute (reference the cell
in the first sheet) while others are relative (same cell location but in the
new sheet). How can I control or change what each name does?

--

Dave Peterson


--

Dave Peterson

I could not completly reproduce it either except that if I went to delete the
Ta 'Eng(2)' it would first remove the 'Eng(2)' reference and become Ta. If I
removed the name a second time it would be completely removed from the file.
I just have not figured out how to really control when a name is sheet level
or global.

"Dave Peterson" wrote:

I couldn't reproduce those results in my testing.

On the new worksheet, each of the names was changed to a sheet level name, like:
'Eng(2)'!Ta

If you try it in a brand new worksheet in a brand new workbook, can you
reproduce it?

NHMM wrote:

I am not talking about the performance of names in formulas but where the
names tie back to.

For Example:
In Sheet "ENG(1)"
I have the following names:
Ta = Cell A1 (In ENG(1))
Tf = Cell A2 (In ENG(1))
Tm = Cell A3 (In ENG(1))

If I right click on the ENG(1) tab and select Move or Copy / Create A Copy
and make a copy of this sheet in the same Excel Document I get the following
names in the new sheet (By choosing Insert Name Define while in the new
sheet)

New Sheet is named ENG(2)
Ta = Cell A1 (In ENG(1))
Tf = Cell A2 (In ENG(2))
Tm = Cell A3 (In ENG(2))

Notice that Ta still reference the first sheet (ENG(1)) while the other two
moved their reference to ENG(2)

I hope that makes sense.

I will check out the name manager - thanks

"Dave Peterson" wrote:

I'm not sure I understand.

Are you saying that when you copy a worksheet that contains ranges that are
named, then the new sheet has the same name that points back to the original
worksheet?

Or are you describing the behavior of names in formulas in cells on the
worksheet.

In either case, maybe an example of what you mean would make it more clear
(well, for me anyway).

And no matter what you're doing...

If you're working with names, get Jan Karel Pieterse's (with Charles Williams
and Matthew Henson) Name Manager:

You can find it at:
NameManager.Zip from http://www.oaltd.co.uk/mvp

It'll make working with names much easier.



NHMM wrote:

I have a sheet containing a number of named cells. When I make a copy of the
sheet inside the same excel file some names are absolute (reference the cell
in the first sheet) while others are relative (same cell location but in the
new sheet). How can I control or change what each name does?

--

Dave Peterson


--

Dave Peterson

Did you download that name manager. It may help you understand global v. local
names.

NHMM wrote:

I could not completly reproduce it either except that if I went to delete the
Ta 'Eng(2)' it would first remove the 'Eng(2)' reference and become Ta. If I
removed the name a second time it would be completely removed from the file.
I just have not figured out how to really control when a name is sheet level
or global.

"Dave Peterson" wrote:

I couldn't reproduce those results in my testing.

On the new worksheet, each of the names was changed to a sheet level name, like:
'Eng(2)'!Ta

If you try it in a brand new worksheet in a brand new workbook, can you
reproduce it?

NHMM wrote:

I am not talking about the performance of names in formulas but where the
names tie back to.

For Example:
In Sheet "ENG(1)"
I have the following names:
Ta = Cell A1 (In ENG(1))
Tf = Cell A2 (In ENG(1))
Tm = Cell A3 (In ENG(1))

If I right click on the ENG(1) tab and select Move or Copy / Create A Copy
and make a copy of this sheet in the same Excel Document I get the following
names in the new sheet (By choosing Insert Name Define while in the new
sheet)

New Sheet is named ENG(2)
Ta = Cell A1 (In ENG(1))
Tf = Cell A2 (In ENG(2))
Tm = Cell A3 (In ENG(2))

Notice that Ta still reference the first sheet (ENG(1)) while the other two
moved their reference to ENG(2)

I hope that makes sense.

I will check out the name manager - thanks

"Dave Peterson" wrote:

I'm not sure I understand.

Are you saying that when you copy a worksheet that contains ranges that are
named, then the new sheet has the same name that points back to the original
worksheet?

Or are you describing the behavior of names in formulas in cells on the
worksheet.

In either case, maybe an example of what you mean would make it more clear
(well, for me anyway).

And no matter what you're doing...

If you're working with names, get Jan Karel Pieterse's (with Charles Williams
and Matthew Henson) Name Manager:

You can find it at:
NameManager.Zip from http://www.oaltd.co.uk/mvp

It'll make working with names much easier.



NHMM wrote:

I have a sheet containing a number of named cells. When I make a copy of the
sheet inside the same excel file some names are absolute (reference the cell
in the first sheet) while others are relative (same cell location but in the
new sheet). How can I control or change what each name does?

--

Dave Peterson


--

Dave Peterson


--

Dave Peterson