Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.docmanagement
yvonnedemulder
 
Posts: n/a
Default Update Excel table in Word automatically from data in Excel

Ive 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.
Ive got to change the marks in Excel a lot of times, but I dont 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)

  #2   Report Post  
Posted to microsoft.public.word.docmanagement
Carol
 
Posts: n/a
Default Update Excel table in Word automatically from data in Excel

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

"yvonnedemulder" wrote:

Ive 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.
Ive got to change the marks in Excel a lot of times, but I dont 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)

  #3   Report Post  
Posted to microsoft.public.word.docmanagement
yvonnedemulder
 
Posts: n/a
Default Update Excel table in Word automatically from data in Excel

Can you tell me how to do this?

"Carol" wrote:

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

"yvonnedemulder" wrote:

Ive 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.
Ive got to change the marks in Excel a lot of times, but I dont 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)

  #4   Report Post  
Posted to microsoft.public.word.docmanagement
CyberTaz
 
Posts: n/a
Default Update Excel table in Word automatically from data in Excel

Hi Yvonne-

In an Excel file, select & copy a 'table', or range of cells. Go to your
Word doc & use EditPaste 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 |:)

"yvonnedemulder" wrote:

Can you tell me how to do this?

"Carol" wrote:

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

"yvonnedemulder" wrote:

Ive 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.
Ive got to change the marks in Excel a lot of times, but I dont 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)

  #5   Report Post  
Posted to microsoft.public.word.docmanagement
yvonnedemulder
 
Posts: n/a
Default Update Excel table in Word automatically from data in Excel

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

Yvonne
(Holland)


"CyberTaz" wrote:

Hi Yvonne-

In an Excel file, select & copy a 'table', or range of cells. Go to your
Word doc & use EditPaste 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 |:)

"yvonnedemulder" wrote:

Can you tell me how to do this?

"Carol" wrote:

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

"yvonnedemulder" wrote:

Ive 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.
Ive got to change the marks in Excel a lot of times, but I dont 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)

Reply
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Word 97 in Windows XP to maintain formatting Charlie''s Word VBA questions Microsoft Word Help 22 May 20th 23 08:51 PM
hard space between words. Sandy L Microsoft Word Help 7 May 5th 06 08:25 PM
Excel data into Word table Melinda Mailmerge 1 October 13th 05 04:47 AM
Envelope Address GR New Users 5 April 24th 05 09:48 PM
Specific Email Merge w/ Specific Attachements Mark B Mailmerge 9 February 21st 05 05:10 AM


All times are GMT +1. The time now is 12:34 AM.

Copyright ©2000 - 2023, Jelsoft Enterprises Ltd.
Copyright 2004-2023 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"