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

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
>
>

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
> >
> >

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
> > >
> > >