Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Re: Linking one table to another table within a word document

505 views
Skip to first unread message

Jezebel

unread,
Jul 21, 2004, 5:11:20 PM7/21/04
to
Link in what sense? Cross-refer to values within the tables, or graphically
link the two table objects for formatting purposes?


"Alexandra" <Alex...@discussions.microsoft.com> wrote in message
news:97A18E81-AD4F-423B...@microsoft.com...
> Hi, I'm trying to link two tables together within a Word document. The
only way that I was successful in doing this, was by linking it to an Excel
workbook and using a new worksheet for each table. Unfortunately, I cannot
use this method because of it's intended purpose. It became too confusing
dealing with two documents rather than one. I either need to link the tables
using embedded Excel worksheets or Word tables. It involves different
formulas etc. Is there any way to do this? Thanks.
>


Alexandra

unread,
Jul 22, 2004, 8:48:01 AM7/22/04
to
I want to cross-refer to values within the tables. It would be easiest to do this with embedded excel worksheets, but I can't get it to work. I've created one workbook with all of my data and I embedded the different worksheets of it in different locations within the document. When I change information in one worksheet, it doesn't show up in the other worksheets. The changes can only be found by double clicking on one worksheet and, when in edit mode, looking at the different worksheets in the same workbook. Is there a way to display the worksheets so that when you change data in one, it can be changed in the appropriate place of another one?

Alexandra

unread,
Jul 22, 2004, 8:52:02 AM7/22/04
to
I want to cross-refer to values within tables. The easiest way for me to work with my data is within excel, so I've been trying to get this to work with one embedded workbook. I put the different worksheets of this workbook in different locations within the document. Unfortunately, when I change the data in one worksheet, it won't show up in other places in the document. The changes are only seen when I double click to edit on the worksheet and look at the different worksheets from there. How can I see the changes in other places in the document? Is this possible? Thanks!

Alexandra

unread,
Jul 22, 2004, 8:53:06 AM7/22/04
to
I want to cross-refer to values within tables. The easiest way for me to work with my data is within excel, so I've been trying to get this to work with one embedded workbook. I put the different worksheets of this workbook in different locations within the document. Unfortunately, when I change the data in one worksheet, it won't show up in other places in the document. The changes are only seen when I double click to edit on the worksheet and look at the different worksheets from there. How can I see the changes in other places in the document? Is this possible? Thanks!

Jezebel

unread,
Jul 22, 2004, 8:03:26 PM7/22/04
to
You could do it if the spreadsheets were linked rather than embedded, and
all part of the same workbook.

Alternatively, you can use bookmarks to refer to specific cells in a Word
table, then use REF fields to refer to the bookmarked values. Clumsy if
you've got many such to do. If the focus of the work is primarily data,
perservere with Excel.


"Alexandra" <Alex...@discussions.microsoft.com> wrote in message

news:61E4325B-8326-4067...@microsoft.com...

Henderson@discussions.microsoft.com John Henderson

unread,
Jul 29, 2004, 10:39:05 AM7/29/04
to
I am trying to the same thing. I have multiple embedded Excel Worksheets (no linked to external files) and would like to link them with the word document.

Is this possible? If so How?

0 new messages