I have a number of workbooks (B) that, through various formulae, look at
another workbook (A) for salary information.

I've added some rows to a named range in (A) and as a result the formulae in
(B) now throw up errors.

Is there an easy way to fix this and how do I avoid the problem in future?

Thanks for any help.