I'm trying to link two cells between two excel sheets. So for example cell A5
from document a into cell B5 into document b. My question is,i linked the
two using an "=" in cell b5 then clicking on cell A5 from document a to
complete the linking.

The problem is i want to be able to insert rows into document A and have
only A5 be linked to B5. When i insert rows in document a anywhere above row
5, it shifts the rown down and the link as well.

Is there any way to permanently link a Cell between documents without the
auto/smart insert feature changing the linking ?