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.