Named Cell Ranges
 

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.

Please ignore this!!! It's a repeat!!

"Blackcat" wrote:

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.