Updating sources for multiple links simultaneously

[NukedWhale]

Hello,

I will try to explain my situation as best as I can.

I have master word document A, which contains several links to cells in master excel document A. For a particular task I need to make a copy of master word document A and a copy of master excel document A. We'll call these new documents word B and excel B. What I need to do is make my Word B document change the source of all of it's links to Excel B, from master excel document A, so word B will update it's links from excel B. Is there any way to do this quickly and easily.

Currently what I've been doing is copying word b and excel b to my usb key, having somebody else open it on their computer (so it can't find excel A, and switches to excel B), then saving the documents and copying them back to my computer.

I'm hoping there is a better way. Thanks in advance.

NW

[Anne Troy]

Did you try Edit-->Links?

Or, you can view field codes (Alt+F9) and do a Find/Replace.

[NukedWhale]

Edit links requires me to change the source paths one link at a time. Anyway to change the source paths for multiple links at once?