Hi, Heather,
Technically you can do it, but are you sure you need such
a complicated solution?
(In case you are not aware -- you can link an embedded
Excel worksheet object directly onto a PowerPoint slide --
without using an embedded Word table -- if that is an
option for you. It's much simpler than involving the
third application. To do that, copy the portion you need
of the Excel worksheet; then, in PowerPoint, select Edit,
Paste Special -- choose Microsoft Office Excel Worksheet
Object as the type and click to select the Paste Link
option.)
If you are familiar with that but need to use the Word
table ...
Note that if you do, the links will only update when you
open the embedded Word object -- whenyou place a link in
the embedded Word object, the link is between Word and
Excel. And, you can only really do it for one cell at a
time if it's not the whole table -- pasting several cells
as links from Excel into part of a Word table will cause
them to be pasted as a nested table into the first cell
of your Word selection.
Note that, with a solution this complex, you might have
reason to be concerned about loss of data integrity --
particularly if your tables are going to require heavy
editing.
However, if you want to do it this way -- here's how:
1. open the embedded Word object
2. copy the first Excel worksheet cell you want to link
3. Back in the opened embedded table, click into the cell
where you want the link to appear
4. Go to Edit, Paste Special -- click to select 'Paste
link' and then click OK.
Please save frequently and save backups of everything if
you go this route.
If you'd like help finding a simpler solution, feel free
to e-mail a sample of what you're working on.
Best,
Stephanie Krieger
author of Microsoft Office Document Designer
(from Microsoft Press)
e-mail: (e-mail address removed)
blog: arouet.net
