Excel Link

[Guest]

I have a spreadsheet that has several different groups of information on it
(i.e., one for each Item # in Word). They are all on one sheet so that all
the columns line up when linked into Word.

In Excel, if I add or delete a line to a portion of the data, none of the
links in word (after the change) are able to update the new position - so
everything is off one line. Is there a way around this - other than
re-copying and re-pasting the link?

TIA

 

[Cindy M.]

Hi =?Utf-8?B?S2FyaW4=?=,

I have a spreadsheet that has several different groups of information on it
(i.e., one for each Item # in Word). They are all on one sheet so that all
the columns line up when linked into Word.

In Excel, if I add or delete a line to a portion of the data, none of the
links in word (after the change) are able to update the new position - so
everything is off one line. Is there a way around this - other than
re-copying and re-pasting the link?

Which version of Word are we dealing with?

I gather from your problem description that you're selecting, copying and
paste-linking the information a block at a time (by item)? So the shift you're
referring to is that entries are appearing under the incorrect item?

Have you specifically used Excel range names to identify each "block", and
used those range names in your links? That will be most "automatic", once you
get it set up.

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 17 2005)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question or
reply in the newsgroup and not by e-mail

 

[Guest]

Thank you! That was the missing piece of information I needed.