Reply
 
Thread Tools Display Modes
  #1   Report Post  
KSit
 
Posts: n/a
Default Linking Excel data to tables in Word

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,


  #2   Report Post  
macropod
 
Posts: n/a
Default

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


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




---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.799 / Virus Database: 543 - Release Date: 19/11/2004


  #3   Report Post  
ksit
 
Posts: n/a
Default

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

"macropod" wrote:

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


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




---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.799 / Virus Database: 543 - Release Date: 19/11/2004



  #4   Report Post  
macropod
 
Posts: n/a
Default

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


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

"macropod" wrote:

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


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




---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.799 / Virus Database: 543 - Release Date: 19/11/2004





---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.799 / Virus Database: 543 - Release Date: 19/11/2004


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
In typing dates in Word, i.e. "January 12" how do you keep the "1. Carol Microsoft Word Help 2 January 12th 05 08:09 PM
word xp crashes after macros are recorded kharris0405 Microsoft Word Help 3 January 11th 05 10:50 PM
WP Delay Code - Word Equiv Mike G - Milw, WI Microsoft Word Help 6 January 10th 05 04:12 PM
Excel worksheet in Word linked text boxes Eduardo Oliveira Page Layout 0 January 5th 05 11:23 PM
formatting links from excel into word (extra line feeds) JGT Microsoft Word Help 1 December 9th 04 11:01 AM


All times are GMT +1. The time now is 09:24 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"