Reply to thread

Message: [QUOTE="Bob Greenblatt, post: 6805263"] Yes, it is clearer. I do not know of any way to create the links other than cell by cell. If you have several versions of Document A (assuming they are in the same format) then you can change between them by using Change Source in the File-Links dialog. There may be other ways to do this using a file name in document B and the INDIRECT formula, but you'll have to be even clearer about what you are trying to do. For example are there many different document As, each to appear in their own row of Document B? Or do you want the row in document B to only show a current version of document A? Since the source cells are scattered throughout document A, you'll have to build each link manually. [/QUOTE]