Linked Workbooks and Row Insertion

[farhan_babu]

Hi,

Here is my problem,I have two workbooks A and B Workbook A has 18 worksheet of which 13 sheets(Col A,H,Z and 31 cells of each Col) are linked with B. B has 15 Sheets.

If I insert a row in A then the no of cells increased from 31 to 32 but in B Book its remain unchanged.Is there any way to update linkes rows in B Book.

Thanks in advance.

Regars

 

[Mooresmi]

Not that I am aware of.

What you need to do is add the row in B workbook and check the formulas before and after this row to see if everything is, er, kosher.