I have a list of documents that are linked to one Master document.

My problem is this, when I change the documents without the links, like
insert rows, etc., the Master document looses the links. If I am linked to
A2, and A2 becomes A3, the Master Document doesn't see the change. Why?

Is there a way to have the Master document change the cells they are linked
to as the linked cells move?

I hope this clear!

Thanks!

What type of formulas do you have in the linked cells? Or do you just have a
cell reference? (for example =Sheet1!A1)

"Robin" wrote:

I have a list of documents that are linked to one Master document.

My problem is this, when I change the documents without the links, like
insert rows, etc., the Master document looses the links. If I am linked to
A2, and A2 becomes A3, the Master Document doesn't see the change. Why?

Is there a way to have the Master document change the cells they are linked
to as the linked cells move?

I hope this clear!

Thanks!