Linked Cells Staying With Cells Once Linked Workbook Update.
 

Can any one help.

I have a list on sheet 1 of a workbook that has linked cells to cells
in sheet 2, i.e. Sheet2!A5. Sheet 2 is then linked to Sheet1 of another
'master' workbook.

If the 'master' workbook has a new row added and the other workbook is
updated the new row is added, fine. Problem I have is that now the
linked cells formulas in sheet 1 do not account for the new row,
therefore all values are now wrong.

If I manually insert a new row into sheet 2, the linked cells formulas
in sheet 1 do account for the new row.

Is there any way around this problem, or is it just a Excel 'funny'.

I hope I've explained myself ok and someone out there can help.