Paste special: links

Hi everybody!

I have a big problem with linking in excel. I have 25 smaller files that I would like to gather through linking in one large file. This works excellent with the command "Paste special -> paste link" and the total document is updating together with the source files, except when I add rows to the source files. The range does not extend above what is specified when first copying the link and I have not the faintest clue how to fix this problem! I am open to all suggestions, also those not including linking with "Paste special -> paste link".

Thanks in advance!

//Jenny

I think I might know what you are after.

You might be able to get round your problem using INDIRECT(ADDRESS(...))
thus:
=INDIRECT(ADDRESS(ROW(),COLUMN(),,,"[Book2]Sheet1"))

This will give you the value from Sheet1 in Book2 that is on the same row and column as the cell in which this formula is entered.
ROW() and COLUMN() can be replaced by any formula you want to point to the cell location you want.

The cell location accessed by this formula is now unaffected by anything you do in Book2,
you can insert or delete lines and this will still point to the same cell location.

Mark.