Linked worksheets

[Guest]

I have one spreadsheet that is the master and 2 spreadsheets that are linked
to this master. When I update the master the data does change correctly in
the 2 linked spreadsheets. This happens correctly until I try and add a new
row in the master spreadsheet. If I insert a new row or copy in a new row the
2 linked spreadsheets do not update. (they do not contain the new rows) Is
there something set incorrectly on the documents or is this a limitation of
Excel 2002? Thanks.

 

[Guest]

.. If I insert a new row or copy in a new row the

2 linked spreadsheets do not update.
(they do not contain the new rows) ...

Nothing wrong, that's just the default behaviour of simple link formulas,
eg: =Sheet1!A1

But here's one way to make it happen in the linked sheets the way you want ..

Assume your master is Sheet1

In Sheet2,
Instead of using simple link formulas in A1:
=Sheet1!A1
with A1 then copied across / down

Use instead in A1:
=IF(OFFSET(Sheet1!$A$1,ROW(A1)-1,COLUMN(A1)-1)=0,"",OFFSET(Sheet1!$A$1,ROW(A1)-1,COLUMN(A1)-1))
Then just copy A1 across / down as required. This returns the same kind of
links as the former but with the added flexibility that any new row/col
insertions in Sheet1 (within the linked area) will now be reflected in
Sheet2. Test it out and see for yourself.

---