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