Links in Word not working properly

[Guest]

I have created a link between Excel and Word that anytime I change or update
a cell in Excel, it updates a specific spot in Word. I did this by copying
the cell in Excel and then paste special, paste link as unformatted text in
Word. It worked great until we deleted some rows in Excel and discovered
that the links in Word stays with the row it was linked to so it now updates
with the wrong information. Is there a way to preserve this link so rows can
be deleted or sorted and the correct information will be updated in my Word
document?

Thanks for your help!

 

[Leo Heuser]

I have created a link between Excel and Word that anytime I change or
update
a cell in Excel, it updates a specific spot in Word. I did this by
copying
the cell in Excel and then paste special, paste link as unformatted text
in
Word. It worked great until we deleted some rows in Excel and discovered
that the links in Word stays with the row it was linked to so it now
updates
with the wrong information. Is there a way to preserve this link so rows
can
be deleted or sorted and the correct information will be updated in my
Word
document?

Thanks for your help!

Hi Sue

Maybe you can use this setup.

In your worksheet:
Select the cell and name it. Use Insert > Names > Define or
the Name box (at the extreme left of the formula bar).
Give it the name (e.g) "Number" without quotes.

In your document:
Use <Alt><F9> to see the field code. Replace the part
saying something like Sheet1!R12C3 by Number.
Return to field result with <Alt><F9>. Save the document.

This will work, when you delete or add rows/columns, but
NOT when data is sorted. I believe the latter is not possible,
unless the contains of the cell can be expressed as a formula
(largest number in the set or something). In that case you can put
the formula in another cell and make the link to that cell instead.

 

[Guest]

Hi, Leo!

Thank you! I tried to name the range which I have done before but between
spreadsheets. I didn't know you can do that between Excel and Word. Anyway,
I see that it works and I'm glad you said it won't work when you sort because
that's how I've been testing anything I've tried. I would have re-sorted
this and see that it doesn't work. I guess I'll have to let the group know
that we can't sort this.

Thank you so much for the help. It was driving me crazy!

SueK

 

[Leo Heuser]

Hi, Leo!

Thank you! I tried to name the range which I have done before but between
spreadsheets. I didn't know you can do that between Excel and Word.
Anyway,
I see that it works and I'm glad you said it won't work when you sort
because
that's how I've been testing anything I've tried. I would have re-sorted
this and see that it doesn't work. I guess I'll have to let the group
know
that we can't sort this.

Thank you so much for the help. It was driving me crazy!

SueK

Hi Sue

You're welcome. Thanks for your feedback.
I'm happy to have saved your sanity

Leo

 

[Guest]

Hi, Leo!

Thank you for your suggestion. I've actually named ranges before but
between Excel files. I didn't know it could work between Excel and Word.
Thank you also for mentioning that it won't work when I re-sort them because
that's what I would be doing to test this. Now that I know it won't work
when I re-sort, I'll have to inform the group that we can't re-sort.

Again, thank you! It's been driving me crazy.

I posted a response yesterday but somehow it didn't get posted. Hopefully,
this one will.

SueK