Linking Excel data to tables in Word

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

KSit - 24 Nov 2004 21:53 GMT

Hi,

I have copied an Excel Table and used paste special (paste link) to insert
it in a Word document. However, whenever i update something in the Excel
spreadsheet, the info is not automaticallly updated in Word. I need to
double click on the table in word to activate the worksheet, then the info
will be updated on Word. Is there any way i can create automatic update
links to my table in Excel? Or maybe my method of cut-and-paste is not the
proper way of inserting data to word? Please kindly advise.

Thanks,

Reply to this Message

macropod - 26 Nov 2004 08:35 GMT

Hi KSit,

Depending on how you're doing this, the Word document might not display the
updated Excel results until the Excel Workbook is saved and, even then,
until the Word document is closed and re-opened. What link format are you
using?

Cheers

> Hi,
>
[quoted text clipped - 7 lines]
>
> Thanks,

Reply to this Message

ksit - 26 Nov 2004 15:07 GMT

Hi macropod,

i used copy from excel then 'paste special' and click on 'paste link'.

Is there another way to build an active link?

Thanks,
ksit

> Hi KSit,
>
[quoted text clipped - 21 lines]
> Checked by AVG anti-virus system (http://www.grisoft.com).
> Version: 6.0.799 / Virus Database: 543 - Release Date: 19/11/2004

Reply to this Message

macropod - 26 Nov 2004 21:36 GMT

When you use 'paste special' and 'paste link', you'll see a number of other
formatting options (eg RTF, picture). These all perform somewhat differently
than the default worksheet format, especially where formatting of the output
is concerned. Some may/may not also give you more responsive updating.

Cheers

> Hi macropod,
>
[quoted text clipped - 30 lines]
> > Checked by AVG anti-virus system (http://www.grisoft.com).
> > Version: 6.0.799 / Virus Database: 543 - Release Date: 19/11/2004

Reply to this Message