N
Nancy
I have set up a number of links in worksheets that will be updated quarterly from a source document. Is there any way to insert or at times delete rows in the source document and have it adjust in the worksheets (ie. new cell address). This works if both source docunent and destination document are open at the same time but I have approx. 40 destination worksheets that are saved in their own files. I don't know how to get them to update when new info is added to the source document and they are not opened??
Thanks
Thanks