software

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
quot;DREEDquot; wrote:

gt; I hope some can help!
gt;
gt; I have approx 40 workbooks linked to a central variables workbook.
gt;
gt; Within the variables workbook are a number of defined names covering a range
gt; of cells eg A1:c114 is called maxima.
gt;
gt; I want to insert some additional lines in a some of these ranges. In mot it
gt; workls fine and the linked workbooks update ok. However one range of cells is
gt; causing a problem.
gt;
gt; When the new lines are added the defined name range changes to eg a1:c121
gt; and the formula in the linked workbooks still has the name. However when I
gt; evaluate the formula it show the old range ie a1:c114.
gt;
gt; Can someone suggest a reason why and a way round it.
gt;
gt;
gt; Thanks
gt;
gt;

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

DR

quot;CLRquot; wrote:

gt; You may have actually two files involved. One that you changed, and another
gt; that the formula is looking at which was inadvertantly saved to a different
gt; location and is actually a different file with the old range that has not
gt; been changed.
gt;
gt; hth
gt; Vaya con Dios,
gt; Chuck, CABGx3
gt;
gt;
gt;
gt; quot;DREEDquot; wrote:
gt;
gt; gt; I hope some can help!
gt; gt;
gt; gt; I have approx 40 workbooks linked to a central variables workbook.
gt; gt;
gt; gt; Within the variables workbook are a number of defined names covering a range
gt; gt; of cells eg A1:c114 is called maxima.
gt; gt;
gt; gt; I want to insert some additional lines in a some of these ranges. In mot it
gt; gt; workls fine and the linked workbooks update ok. However one range of cells is
gt; gt; causing a problem.
gt; gt;
gt; gt; When the new lines are added the defined name range changes to eg a1:c121
gt; gt; and the formula in the linked workbooks still has the name. However when I
gt; gt; evaluate the formula it show the old range ie a1:c114.
gt; gt;
gt; gt; Can someone suggest a reason why and a way round it.
gt; gt;
gt; gt;
gt; gt; Thanks
gt; gt;
gt; gt;

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. lt;ggt;

Vaya con Dios,
Chuck, CABGx3
quot;Davidquot; wrote:

gt; I've checked the links and they appear to be ok. The other named ranges in
gt; the same workbook are fine.
gt;
gt; DR
gt;
gt; quot;CLRquot; wrote:
gt;
gt; gt; You may have actually two files involved. One that you changed, and another
gt; gt; that the formula is looking at which was inadvertantly saved to a different
gt; gt; location and is actually a different file with the old range that has not
gt; gt; been changed.
gt; gt;
gt; gt; hth
gt; gt; Vaya con Dios,
gt; gt; Chuck, CABGx3
gt; gt;
gt; gt;
gt; gt;
gt; gt; quot;DREEDquot; wrote:
gt; gt;
gt; gt; gt; I hope some can help!
gt; gt; gt;
gt; gt; gt; I have approx 40 workbooks linked to a central variables workbook.
gt; gt; gt;
gt; gt; gt; Within the variables workbook are a number of defined names covering a range
gt; gt; gt; of cells eg A1:c114 is called maxima.
gt; gt; gt;
gt; gt; gt; I want to insert some additional lines in a some of these ranges. In mot it
gt; gt; gt; workls fine and the linked workbooks update ok. However one range of cells is
gt; gt; gt; causing a problem.
gt; gt; gt;
gt; gt; gt; When the new lines are added the defined name range changes to eg a1:c121
gt; gt; gt; and the formula in the linked workbooks still has the name. However when I
gt; gt; gt; evaluate the formula it show the old range ie a1:c114.
gt; gt; gt;
gt; gt; gt; Can someone suggest a reason why and a way round it.
gt; gt; gt;
gt; gt; gt;
gt; gt; gt; Thanks
gt; gt; gt;
gt; gt; gt;