A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Word » Tables
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Linking one table to another table within a word document



 
 
Thread Tools Display Modes
  #1  
Old July 21st, 2004, 07:01 PM
Alexandra
external usenet poster
 
Posts: n/a
Default Linking one table to another table within a word document

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.

  #2  
Old July 21st, 2004, 10:11 PM
Jezebel
external usenet poster
 
Posts: n/a
Default Linking one table to another table within a word document

Link in what sense? Cross-refer to values within the tables, or graphically
link the two table objects for formatting purposes?


"Alexandra" wrote in message
...
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.



  #3  
Old July 22nd, 2004, 01:48 PM
Alexandra
external usenet poster
 
Posts: n/a
Default Linking one table to another table within a word document

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?

"Jezebel" wrote:

Link in what sense? Cross-refer to values within the tables, or graphically
link the two table objects for formatting purposes?


"Alexandra" wrote in message
...
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.




  #4  
Old July 22nd, 2004, 01:52 PM
Alexandra
external usenet poster
 
Posts: n/a
Default Linking one table to another table within a word document

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" wrote:

Link in what sense? Cross-refer to values within the tables, or graphically
link the two table objects for formatting purposes?


"Alexandra" wrote in message
...
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.




  #5  
Old July 22nd, 2004, 01:53 PM
Alexandra
external usenet poster
 
Posts: n/a
Default Linking one table to another table within a word document

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" wrote:

Link in what sense? Cross-refer to values within the tables, or graphically
link the two table objects for formatting purposes?


"Alexandra" wrote in message
...
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.




  #6  
Old July 23rd, 2004, 01:03 AM
Jezebel
external usenet poster
 
Posts: n/a
Default Linking one table to another table within a word document

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" wrote in message
...
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" wrote:

Link in what sense? Cross-refer to values within the tables, or

graphically
link the two table objects for formatting purposes?


"Alexandra" wrote in message
...
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.






  #7  
Old July 29th, 2004, 03:39 PM
John Henderson
external usenet poster
 
Posts: n/a
Default Linking one table to another table within a word document

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?

"Jezebel" wrote:

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" wrote in message
...
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" wrote:

Link in what sense? Cross-refer to values within the tables, or

graphically
link the two table objects for formatting purposes?


"Alexandra" wrote in message
...
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.







 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
linking Excel table to word Thrava General Discussion 3 July 21st, 2004 07:58 PM
Import Fields from Word Table into access record Gordzilla General Discussion 1 June 17th, 2004 06:45 PM
changes to normal.dot Dianah New Users 7 June 17th, 2004 01:19 AM
Keeping Records in Linking Table Accurate (Long Post) Ben Johnson Running & Setting Up Queries 0 June 14th, 2004 08:13 AM
word error mac General Discussions 1 May 6th, 2004 08:14 AM


All times are GMT +1. The time now is 11:03 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.