Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

Word file A has about 100 charts, all of them are linked to about a dozen excel files under folder B.

Now, to try something new, I made a copy: Word file A1 and folder B1.

However, all charts in A1 are still linking to folder B, as the link was defined as \\machineName\sharedFolder\B\b_a.xls, b_b.xls...etc.

Is there a way to update A1's links to poing to excel files under folder B1?

I'm using word 97 and excel 97.

share|improve this question
up vote 2 down vote accepted

Word won't know where to find the files if the the location of the word file or target directory name is changed, therefore you will need to modify the paths in the document manually.

Probably the easiest way to do this is to show field codes Alt + F9 and then do a regular find and replace to substitute "\B\" for "\B1\".

share|improve this answer
you are the man! :D – athos Jun 14 '13 at 7:12

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.