A simple way of doing this without code is:
1. Open both workbooks, allowing the target workbook to update its links.
2. Insert two columns into the source workbook
3. Save & close the target workbook
4. Close the source workbook without saving
Now, when you re-open the target workbook, all the column references should be correct.

The above process could, of course, be automated with a macro (without any of the circumlocutions of what's been discussed so far).

Rob: Please don't solicit or accept requests for off-line assistance.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]