Chaging Links from Excel Spreadsheet

[Hank Youngerman]

I have a couple of Word documents that have a lot of links from Excel
spreadsheets. While this is a useful feature, it seems incredibly
cumbersome to make any modifications at all.

I would like to be able to do the following things:

1) Change a large number of links to a different workbook. I can
highlight all the links I want to change, but I appear to have to
click through to the new workbook for each one.
2) Change a large number of links to a different tab in the same
workbook. I can't seem to do this at all.

Also, is there a way to find out what a particular item is linking
too. For example, suppose I have the word "Detroit" in a Word
document, and I know it is a link. How can I find where the link is
coming from? It seems like the only way is to open the list of links
and then try to figure it out, which can be very difficult.
Particuarly since the links box will not resize, so you often can't
see what's going on.

Is there any resource that covers these things? Anything on the
Microsoft site? Any books?

 

[Steve G]

I have a couple of Word documents that have a lot of links from Excel
spreadsheets. While this is a useful feature, it seems incredibly
cumbersome to make any modifications at all.

I would like to be able to do the following things:

1) Change a large number of links to a different workbook. I can
highlight all the links I want to change, but I appear to have to
click through to the new workbook for each one.
2) Change a large number of links to a different tab in the same
workbook. I can't seem to do this at all.

Also, is there a way to find out what a particular item is linking
too. For example, suppose I have the word "Detroit" in a Word
document, and I know it is a link. How can I find where the link is
coming from? It seems like the only way is to open the list of links
and then try to figure it out, which can be very difficult.
Particuarly since the links box will not resize, so you often can't
see what's going on.

Is there any resource that covers these things? Anything on the
Microsoft site? Any books?

----------------------------------------------------------------------

You might try the "find and replace" procddures in both Excel and
Word. I would start with Excel and get the new tab or work sheet
ready. Then I would go into Word and replace the old links with the
new links.

Steve G