Links
I'm not sure what you meant by "don't work" in your original post. However,
I'm going to assume that the links aren't actually being broken, but that
the update in the doc isn't what you expected based on inserting rows.
If I'm on track with what you meant, the embedded Excel object will *not*
change in _size_ in the Word doc but the changes made in the displayed area
should be visible. IOW, Inserted/deleted rows or columns as well as any
other changes should take place immediately if the doc & workbook are both
open when the change is made, but the amount of space occupied in the doc
will not change - 10 rows tall to begin with is all that will show even if
you add 50 rows in the worksheet. Anything beyond the established object
space will not be displayed. If you want an area more or less than the
original object you will have to replace it with a new copy.
If the *content* within the object's area isn't updating, go to EditLinks &
make sure the link's Update Method is set to Automatically Update.
Also, when opening the doc while the workbook is *not* open should generate
a prompt as to whether the updating should be allowed.
--
HTH |:)
Bob Jones
[MVP] Office:Mac
"Jeannine" wrote in message
...
Can you/anyone suggest a good place to learn about the "ins and outs" of
linking cells in an Excel worksheet to a Word document? I checked out a
book (3 inches thick) at the library that has only 1 sentence about links.
Thanks, Jeannine
|