Hi,

I have a spreadsheet that has lots of Named Formulas (to ensure
consistancy and avoid errors). Each formula refers to data in the three
rows directly above it (i.e. in the same column). The formula is
repeated further down in each column referring to more data.

I've been asked to insert a new row into each set of data, however when
I do this the named formulas don't automatically adjust for it in the
way that a directly inserted formula would i.e. the new row is
referenced when I'd rather point to the original cells. I presume this
is due to the fact that the formulas are relative rather than absolute.


Since the formulas are very complex I don't want to manually adjust
them in the Named Range box. The only thing I can think of is to
convert them all to normal formulas, insert the new row, then convert
back to named ranges. Is there way to sort this out?

Best Regards,

CalumMurdo Kennedy