[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 , then saving the documents and copying them back to my computer.

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

NW

[Sponsor]

[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?