Update Excel table in Word automatically from data in Excel

[Guest]

I’ve got an Excel document with many tables in 30 different sheets.
I want to make an Word document, in which I want to insert the excel tables
between the text.
The data in Excel is made up out of column headers and row headers with list
of marks under it.
I’ve got to change the marks in Excel a lot of time’s, but I don’t want to
change the Word document all the time.
So the tables in the Word document have to change with the changes I make in
the Excel document.

I know this is possible, but no one I know seems to know how to do this.
I would really be grateful with an answer, because I want to use this in my
Final Project.

Yvonne de Mulder (From Holland)
(e-mail address removed)

 

[Guest]

I'm not one hundred percent certain, but I think what you need to do is embed
the tables in Word.

 

[Guest]

Can you tell me how to do this?

I'm not one hundred percent certain, but I think what you need to do is embed
the tables in Word.

 

[Guest]

Hi Yvonne-

In an Excel file, select & copy a 'table', or range of cells. Go to your
Word doc & use Edit>Paste Special. Select the Option for Paste Link, then
choose one of the items in the list, such as:

1) MS Office Excel Worksheet Object - appears in the doc as a 'picture'
which cannot be edited in Word but is linked to the original Excel file,

2) Formatted Text - appears as a Word Table, but retains _most_ of the
formatting (sometimes there are issues that need to be adjusted, such as
column widths) used in the Excel File & can be treated as a Word table, or

3) Unformatted Text - which also appears as a Word table & can be treeated
as such, but does _not_ carry the formatting that was used in Excel.

The other choices are also explained in the Paste Special dialog box when
you click on them, but these are the most likely ones. More info can be found
in Word Help, as well.

HTH |:>)

 

[Guest]

You are really great
It works!
I thought it would be very difficult, but this is so easy!!
Thank you very much!!!!!

Yvonne
(Holland)