Col A of spreadsheet (the recipient) contains Anchored cell refs to another
workbook (the source), and then I enter info in Col B which relates only to
the cell in Col A (eg B1 to A1 etc).
If I later insert rows within the data of the source workbook, and update
the recipient spreadsheet upon opening it, the data in Col B no longer
matches the cell in Col A. Is there any way of keeping the relationship
between the adjacent cells, ie some form of anchoring, so that this does not
happen?