Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Linked worksheets
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Linked worksheets
.. 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. -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "superdl1" wrote: 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Linked formatting across worksheets | Excel Discussion (Misc queries) | |||
why do linked worksheets keep getting hidden? | Excel Discussion (Misc queries) | |||
Linked Worksheets | Excel Worksheet Functions | |||
Linked worksheets in Excel | Excel Discussion (Misc queries) | |||
Linked worksheets | Excel Discussion (Misc queries) |