linking Excel table to word

  • Thread starter Thread starter Thrava
  • Start date Start date
T

Thrava

Can anyone tell me how I can have an excel table linked to
a word table so that the word table dynamically updates
itself based on the values in excel cells?

Much appreciate it if anyone can point me to direction
Thrava
 
Hi
in MS Word just insert the Excel sheet as Excel object (Edit - Paste
Special)
 
Hi Thrava,

As Frank says, you can use Edit|Paste Special to paste the required part of
the worksheet into Word. If you use the 'paste link' option that comes with
Edit|Paste Special, the Word table can be set to update as the data in the
Excel file changes.

You also have a number of paste format options available via Edit|Paste
Special. If you need to insert the Excel data into particular cells in an
existing Word table, select the Excel cells one at a time and use 'Formatted
text (RTF)' when pasting them into the Word table cells.

Cheers
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Linking Excel data to Word table 1
Linking a cel from Excel to a Cell in a Word table 3
Link Excel S/Sheet cells to Table in Word document 2
VBA Excel - Select a value from one cell in Excel to update a SQL table 1
can I link my Excel Cells to a table in a Word Document 5
Word Adding a watermark to a table 1
VLOOKUP isn't working properly in Excel on Mac 1
Copying a table from Word 5

Back
Top