When you are linking to an external reference, is there a way to keep the destination workbook upto date.
For example, source workbook, the colume will alway remain the same, but the row number might change. When I open my destination workbook and update it, it doesn't always keep the correct value? Should it? If so, how do I get it to work?
For example, source workbook, the colume will alway remain the same, but the row number might change. When I open my destination workbook and update it, it doesn't always keep the correct value? Should it? If so, how do I get it to work?