Linking Word and Excel

  • Thread starter Thread starter Maureen
  • Start date Start date
M

Maureen

I have a Word document with a large number of tables
linked to cells in an Excel spreadsheet. The tables in the
worksheet are in the same order as those in the Word
document. I would like to insert a new table between other
tables linked to the Excel spreadsheet but when I insert
the new table between the others in the Excel spreadsheet,
it invalidates all the other linked information. I take
this to mean that the links are not absolute references.
Is there any way to do this without having to reconstruct
the links?

Thanks
 
Hi Maureen,

If I'm following things correctly, you'll have to ssign RANGE
names to the cells in Excel and use these in the LINK fields.
Excel is "smart enough" to notice when you move things around
and adjust its *relative* cell refernces to maintain a
connection to the original cell. Outside applications don't
integrate to that extent with the Excel application, so only
see, literally, what's in the specified cell.

Press ALT+F9 in Word to toggle field codes on and off. You
should seem something like this for the information coming in
from Excel

{ LINK Excel.Sheet.8 "C:\\CM\\Test.xls" "Sheet1!R1C1" \a \f 4
\h }

If you then assigned the name FirstCell to cell A1 in Sheet1,
you'd modify the field code to:

{ LINK Excel.Sheet.8 "C:\\CM\\Test.xls" "Sheet1!FirstCell" \a
\f 4 \h }
I have a Word document with a large number of tables
linked to cells in an Excel spreadsheet. The tables in the
worksheet are in the same order as those in the Word
document. I would like to insert a new table between other
tables linked to the Excel spreadsheet but when I insert
the new table between the others in the Excel spreadsheet,
it invalidates all the other linked information. I take
this to mean that the links are not absolute references.
Is there any way to do this without having to reconstruct
the links?
Click to expand...

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun
8 2004)
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 :-)
 
Back
Top