bstocks@lsnetworks.net
New Member
I need to use spreadsheets maintained by others to populate my spreadsheet. I do not control the source workbooks. I can establish links to the other workbooks and the links are valid even if the originator inserts or moves columns or rows. However, if the rows are resorted in the source workbooks, I lose my data integrity and the links are no longer valid. I have tried Edit Links / Update Values, but that has no effect. Is there a way to maintain the links even if the originator resorts the rows?