Defined names
 

I hope some can help!

I have approx 40 workbooks linked to a central variables workbook.

Within the variables workbook are a number of defined names covering a range
of cells eg A1:c114 is called maxima.

I want to insert some additional lines in a some of these ranges. In mot it
workls fine and the linked workbooks update ok. However one range of cells is
causing a problem.

When the new lines are added the defined name range changes to eg a1:c121
and the formula in the linked workbooks still has the name. However when I
evaluate the formula it show the old range ie a1:c114.

Can someone suggest a reason why and a way round it.


Thanks

Defined names
 

You may have actually two files involved. One that you changed, and another
that the formula is looking at which was inadvertantly saved to a different
location and is actually a different file with the old range that has not
been changed.

hth
Vaya con Dios,
Chuck, CABGx3



"DREED" wrote:

I hope some can help!

I have approx 40 workbooks linked to a central variables workbook.

Within the variables workbook are a number of defined names covering a range
of cells eg A1:c114 is called maxima.

I want to insert some additional lines in a some of these ranges. In mot it
workls fine and the linked workbooks update ok. However one range of cells is
causing a problem.

When the new lines are added the defined name range changes to eg a1:c121
and the formula in the linked workbooks still has the name. However when I
evaluate the formula it show the old range ie a1:c114.

Can someone suggest a reason why and a way round it.


Thanks

Defined names
 

I've checked the links and they appear to be ok. The other named ranges in
the same workbook are fine.

DR

"CLR" wrote:

You may have actually two files involved. One that you changed, and another
that the formula is looking at which was inadvertantly saved to a different
location and is actually a different file with the old range that has not
been changed.

hth
Vaya con Dios,
Chuck, CABGx3



"DREED" wrote:

I hope some can help!

I have approx 40 workbooks linked to a central variables workbook.

Within the variables workbook are a number of defined names covering a range
of cells eg A1:c114 is called maxima.

I want to insert some additional lines in a some of these ranges. In mot it
workls fine and the linked workbooks update ok. However one range of cells is
causing a problem.

When the new lines are added the defined name range changes to eg a1:c121
and the formula in the linked workbooks still has the name. However when I
evaluate the formula it show the old range ie a1:c114.

Can someone suggest a reason why and a way round it.


Thanks

Defined names
 

Then all I can suggest is to completely delete the errant RangeName, and
re-establish it....maybe it's some sort of a BrainF**t. <g

Vaya con Dios,
Chuck, CABGx3



"David" wrote:

I've checked the links and they appear to be ok. The other named ranges in
the same workbook are fine.

DR

"CLR" wrote:

You may have actually two files involved. One that you changed, and another
that the formula is looking at which was inadvertantly saved to a different
location and is actually a different file with the old range that has not
been changed.

hth
Vaya con Dios,
Chuck, CABGx3



"DREED" wrote:

I hope some can help!

I have approx 40 workbooks linked to a central variables workbook.

Within the variables workbook are a number of defined names covering a range
of cells eg A1:c114 is called maxima.

I want to insert some additional lines in a some of these ranges. In mot it
workls fine and the linked workbooks update ok. However one range of cells is
causing a problem.

When the new lines are added the defined name range changes to eg a1:c121
and the formula in the linked workbooks still has the name. However when I
evaluate the formula it show the old range ie a1:c114.

Can someone suggest a reason why and a way round it.


Thanks