Gary -
I'm pulling info from excel into word. Do I have to have my excel file open
to update my word file?

"Gary''s Student" wrote:

There is a tiny trick to make this type of linkage much easier than normal.
Everyone knows how to link a cell in one workbook to another cell in a
defferent workbook. We just want to do the same thing to a cell in a Word
Table.

We can cheat! Open both a Word doc and an Excel Workbook

In the Word doc, instead of inserting a Table in the Word doc:

Insert Object Microsoft Excel Worksheet

If you double-click in a cell in the resulting object, you see the embedded
worksheet. Enter data and copy the cell. If you click outside the object,
it changes appearance. It looks just like any other Word table.

Now go to the Work book, select a cell and:

Edit PasteSpecial Paste Link

Link updates work because we have really linked two worksheets (even though
one of them is embedded)
--
Gary''s Student - gsnu200722


"SueK" wrote:

Hi!

I need to create an Excel file that would update from multiple Word documents.
Ex. In Word, I have a table with a cell that has the person responsible for
a project. If the person responsible changes, I'd like cell B2 in Excel to
automatically update with the name change. Is this possible? I tried to
copy, paste special, paste link, Microsoft Office Word Document Object to my
Excel file but anytime I update the Word document, it gives me a message
saying cannot start the source application for this object. Can anyone help?
Is there a way to do this rather than changing all those Word documents to
Excel files?