Changing multiple Word/Excel worksheet links quickly

[wheelwater]

Excel I have a Word document that has fifty liked items from a 12 page Excel
workbook.
I want to change the file names of the Word document and the Workbook while
preserving the links between them AND while preserving the original Word
document and Worksheet.

Doing the re-linking on the newly named files one at a time is too
cumbersome (using Edit, Links, Change Link, etc. for each Item) and time
consuming. I would like to change all links at once and I repeat, I need to
preserve the links.

Any suggestions. TIA.

 

[Jean-Guy Marcil]

wheelwater was telling us:
wheelwater nous racontait que :

Excel I have a Word document that has fifty liked items from a 12
page Excel workbook.
I want to change the file names of the Word document and the Workbook
while preserving the links between them AND while preserving the
original Word document and Worksheet.

Doing the re-linking on the newly named files one at a time is too
cumbersome (using Edit, Links, Change Link, etc. for each Item) and
time consuming. I would like to change all links at once and I
repeat, I need to preserve the links.

For an easy/dirty way no requiring macros:

Do ALT-F9 to toggle between field values and field codes.

All your Excel items in the Word document will change to something like

{LINK Excel.Sheet.8 "C:\\RootFolder\\Excel Stuff\\THis
Project\\MyWorkbook.xls" "MySheet!R83C16:R96C24" \a \p}

Now, do a find/replace

Find \\MyWorkbook.xls"
Replace \\NewWorkbook.xls"

Then do ALT-F9 to toggle the field codes, do CTRL-A to select all and do F9
to update all the links.

By the way, do not start a new thread to reply to a question in another
thread.
--
Salut!
_______________________________________
Jean-Guy Marcil - Word MVP
(e-mail address removed)
Word MVP site: http://www.word.mvps.org

 

[wheelwater]

Where should I be when I start Alt f9? I have tried starting from the word
file, from the word file links window and from the Excel book. In no
situation did Alt f9 do anything

 

[Jean-Guy Marcil]

wheelwater was telling us:
wheelwater nous racontait que :

Where should I be when I start Alt f9? I have tried starting from the
word file, from the word file links window and from the Excel book.
In no situation did Alt f9 do anything

Select a linked item in Word.
Do ALT-F9 (simultaneously), the linked item will be replaced by the
underlying field code. If it isn't then we are not talking about the same
kind of linked item.

--
Salut!
_______________________________________
Jean-Guy Marcil - Word MVP
(e-mail address removed)
Word MVP site: http://www.word.mvps.org

 

[wheelwater]

Jean-Guy
That is one fantastic solution!!! Thank you... you just saved about three
monhts of work for me.

BTW the reason i was confused by the F9 issue was that i use a MS keyboard
that has to have the F lock and the number one number on to operte f keys.

Thanks again.

Wheelwater