You wouldn't believe how long it took me to figure this out (especially the
last step). g

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
Word MVP FAQ site: http://word.mvps.org
Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.

"David" wrote in message
...
Suzanne,

Thank you so much. This solves a problem I have bneen thinking about for
days!
--
David


"Suzanne S. Barnhill" wrote:

You need to replace the display text, then display fields and replace
the
actual HYPERLINK field text, then update the fields.

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
Word MVP FAQ site: http://word.mvps.org
Email cannot be acknowledged; please post all follow-ups to the
newsgroup so
all may benefit.

"BWood" wrote in message
...
Thanks for your help but didn't work.

The Find and Replace feature seems to work only for WITHIN the
documents.
I
need to change all the links in the document that go to a particular
excel,
to go to a diffferent excel. I tried your suggestion and it turned up
with
"0
changes". But, under find the location is something like

C:\Documents and Settings\username\My Documents\blahblah\ blah blah\
and
so
on.xls

Not sure if that is what you meant. Thanks though.



"SHord" wrote:

In Word, press Ctrl+H on your keyboard and the Replace window
appears.
Simply enter the old link in the "Find what" field and enter the new
link in
the "Replace with" field, then click the "Replace All" button at the
bottom
of this window. This will replace the old link with whatever you
entered as
the replacement - throughout the document or template.

"BWood" wrote:

I create an analysis in excel and then link it to a word template.
In
the
process, I need to change the sources of all my links in the
document
to a
different excel. So far, I have been able to either edit each link
individually - a very time consuming and tedious task OR don't
change
the
source and rename the excel file each time to the original source.

So, how do I change ALL the sources at once?

BWood