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