My target worksheet (just one) is linked to several source worksheets (about
50 files). If I want to edit the target worksheet (say, adding additional
rows), does it mean that I have to open all my sources such that the links
can be kept?

I had tried to edit the target without opening the sources, the linked
addresses will all be jumbled up after adding the new rows.

If it is indeed required for the sources to be opened, can EXCEL open 50
files at the same time? Any memory problem here?

Thanks.

zhj23